|
A worksheet’s row-and-column structure can be used to organize and store a ____. |
table |
|
Each row of an Excel worksheet used to create a table can store a record, and each column can store a(n) ____. |
field |
|
In a table, or database, the data related to each person or item is called a ____. |
record |
|
A ____ should be formatted so that the records are easily distinguished. |
table |
|
Which of the following is the path to the Format as Table button? |
(HOME tab | Styles group) |
|
____ causes adjacent rows to have different formatting so that each row in the table is distinguished from surrounding rows. |
Row banding |
|
In a table, a column that contains formulas or functions is called a(n) ____. |
calculated column |
|
The ____ function is used when the table direction is horizontal. |
HLOOKUP |
|
The ____ function is used when a table direction is vertical. |
VLOOKUP |
|
Why is the VLOOKUP function used more often than other lookup functions? |
Because most tables are vertical |
|
The VLOOKUP function uses the left column of the ____ to compare against a particular number in the main table. |
table array |
|
For the VLOOKUP function to work correctly, the table ____ must be in sequence from lowest to highest. |
arguments |
|
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) |
|
Which of the following is the path to the ‘Lookup & Reference’ button? |
(FORMULAS tab | Function Library group) |
|
____ 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 |
|
The Conditional Formatting ____ dialog box displays all of the rules for the current selection or for the entire workbook. |
Rules Manager |
|
Which of the following is NOT a type of conditional formatting? |
Row Banding |
|
You can insert a ____ at the bottom of a table. |
total row |
|
Which of the following is the path to the Total Row check box? |
(TABLE TOOLS DESIGN tab | Table Style Options group) |
|
Data is in ____ sequence if it is in order from lowest to highest. |
ascending |
|
The field or fields selected for sorting records are called ____ keys. |
sort |
|
Which of the following is the path to the ‘Sort & Filter’ button? |
(HOME tab | Editing group) |
|
In the Sort dialog box, shown in the accompanying figure, the ____ is the Sort by field. |
major sort key |
|
When you first create a table, Excel automatically enables ____. |
AutoFilter |
|
If you deselect an item from the filter menu, it is called the filter ____. |
criterion |
|
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 |
|
____ records allows you to pull data from a table so that you can analyze or manipulate the data further. |
Extracting |
|
Like the AutoFilter query technique, the ____ command displays a subset of the table. |
Advanced Filter |
|
The comparison criteria in the ____ range determine the records that will pass the test when the Advanced Filter dialog box is used. |
criteria |
|
Excel includes ____ database functions that allow you to evaluate numeric data in a table. |
12 |
|
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 |
|
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 ____ function is useful when you want to add values in a range only if they meet criteria. |
SUMIF |
|
A ____ total sums all of the data in a row or column. |
grand |
|
The most common subtotal uses the ____ function. |
SUM |
|
____ is extremely useful for making large tables more manageable in size and appearance. |
Outlining |
|
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 |
Share This
Flashcard
