Table Terms in Excel
Excel Tables are made up of columns, column labels, and rows; they can be sorted and/or filtered according to your specifications.
Columns
determine the informational structure of table rows
NOTE: These are the same as database fields.
determine the informational structure of table rows
NOTE: These are the same as database fields.
Column Labels
identify columns; they often have special formatting
NOTE: These are the same as database field names.
identify columns; they often have special formatting
NOTE: These are the same as database field names.
Rows
contain specific data, according to column labels
NOTE: These are the same as database records.
contain specific data, according to column labels
NOTE: These are the same as database records.
AutoFilter
button at top of each Table column; provides quick access to sort and filter tools
button at top of each Table column; provides quick access to sort and filter tools
Sort
arranges Table data in order according to text, numbers, time, date, or specific criteria (also see Using the Sort Command).
NOTE: Unlike filter, sort displays all table data, but puts them in a specific order.
arranges Table data in order according to text, numbers, time, date, or specific criteria (also see Using the Sort Command).
NOTE: Unlike filter, sort displays all table data, but puts them in a specific order.
Filter
displays only data meeting criteria you specify (e.g., name, year) (also see Filtering Your Database).
NOTE: Unlike sorting, filtering hides some table data, showing only that which fits your criteria.
displays only data meeting criteria you specify (e.g., name, year) (also see Filtering Your Database).
NOTE: Unlike sorting, filtering hides some table data, showing only that which fits your criteria.
0 comments:
Post a Comment