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
To change an active table back to a normal range of cells, right-click the table, point to Table on the shortcut menu, and then tap or click ____ on the Table submenu.
Convert to Range
When you first create a table, Excel automatically enables ____.
AutoFilter
Which of the following is NOT a type of conditional formatting?
Row Banding
Which of the following is the path to the ‘Sort & Filter’ button?
(HOME tab | Editing group)
Which of the following is the path to the Format as Table button?
(HOME tab | Styles group)
Which of the following is the path to the Total Row check box?
(TABLE TOOLS DESIGN tab | Table Style Options group)
Why is the VLOOKUP function used more often than other lookup functions?
Because most tables are vertical
With a database function, if one of your arguments is a field name and the field name is text, rather than a cell reference, number, or range, the argument must be enclosed in ____.
quotation marks
You can insert a ____ at the bottom of a table.
total row
____ causes adjacent rows to have different formatting so that each row in the table is distinguished from surrounding rows.
Row Banding
____ formatting allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell.
Conditional
____ is extremely useful for making large tables more manageable in size and appearance.
Outlining