Vocab 1
sorted from lowest to highest, earliest to most recent, alphabetically from A to Z
What is ascending Order?
an advanced filter technique that manipulates records that pass comparison criteria
Criteria range
indicate which items will appear in the table
Selection (check boxes)
used for multiple field sorting, the first group of data to sort
Major Sort Key:
when Excel copies the records that meet the comparison criteria in the criteria range to another part of the worksheet
a method to sort, query and filter the records in a table
AutoFilter
when a filter displays results such as flash drives, CD-R drives and drivers. Symbols such as ? and *.
Wildcard characters
when the table direction is horizontal, or across the worksheet
HLookup function
used for multiple field sorting, the last/least important group of data to sort
Minor Sort Key
sorted from highest to lowest, most recent to earliest or alphabetically from Z to A
AKA Computational Field: a field or column in a table that contains a formula, function, cell reference, structured reference or condition
Calculated Field
arranging records in a specific sequence
Sorting
used for multiple field sorting, the second group of data to sort
Intermediate Sort Key
a logical rule by which data is tested and chosen
Criteria
counts the number of numeric entries in a table field that passes a test
DCOUNT function
represents the column location of the return value within the lookup table
Column index number
data entered in the Search box on the filter menu
Search string
a table that contains functions that allow you to look up rankings
this command allows you to enter custom criteria, such as multiple options or ranges of numbers
Custom filter
sums all of the data in a row or column. Can be created automatically, as long as the data is sorted
Grand Total
used with subtotals. The field on which you sort
Control Field
The field or fields you select to sort the records
Sort Keys
the data, or location of the data that you want to look up
functions that allow you to evaluate numerical data in a table. Excel has 12 of these.
Database functions
finds the average of numbers in a table field that pass a test