Chapter 6 Flashcards
A ____ should be formatted so that the records are easily distinguished.
table
A ____ total sums all of the data in a row or column.
grand
A worksheet’s row-and-column structure can be used to organize and store a ____.
table
Data is in ____ sequence if it is in order from lowest to highest.
ascending
Each row of an Excel worksheet used to create a table can store a record, and each column can store a(n) ____.
field
Excel includes ____ database functions that allow you to evaluate numeric data in a table.
12
For the VLOOKUP function to work correctly, the table ____ must be in sequence from lowest to highest.
arguements
f you deselect an item from the filter menu, it is called the filter ____.
criterion
In a table, a column that contains formulas or functions is called a(n) ____.
calculated column
In a table, or database, the data related to each person or item is called a ____.
record
Like the AutoFilter query technique, the ____ command displays a subset of the table.
Advanced Filter
The Conditional Formatting ____ dialog box displays all of the rules for the current selection or for the entire workbook.
Rules Manager
The VLOOKUP function uses the left column of the ____ to compare against a particular number in the main table.
Table Array
The ____ function is used when the table direction is horizontal.
HLookup
The ____ function is useful when you want to add values in a range only if they meet criteria.
SUMIF
The ____ function returns the value or reference of the cell at the intersection of a particular row and column in a table or range.
index
The ____ function tells you the relative position of an item in a range or table, which is the same as a specified value in a specified order.
Match
The comparison criteria in the ____ range determine the records that will pass the test when the Advanced Filter dialog box is used.
criteria
The field or fields selected for sorting records are called ____ keys.
sort
The left column values in a table array are called table ____.
arguments
The general form of the VLOOKUP function is ____.
=VLOOKUP(lookup_value, lookup_table, col_index_num)
The most common subtotal uses the ____ function.
SUM
The process of filtering activity based on one or more filter criteria is called a ____.
query
The values ____ satisfy a custom filter criteria that displays records in which the Experience field contains a value greater than or equal to 3 and less than or equal to 5.
3,4,5
