Chapter 6

Excel turns on the outline feature automatically when you create subtotals.

The HLOOKUP and VLOOKUP functions can be inserted by clicking the 'Lookup & Reference' button (FORMULAS tab | Function Library group).

For the VLOOKUP function to work correctly, the table ____ must be in sequence from lowest to highest.

The ____ function is used when a table direction is vertical.

The ____ function returns the value or reference of the cell at the intersection of a particular row and column in a table or range

The DAVERAGE function counts the number of numeric entries in a table field that pass a test.

Which of the following is the path to the 'Lookup & Reference' button?

The Subtotal command displays outline symbols beside the rows or above the columns of the data you want to group.

All of the database functions require a field name as one of the arguments

The general form of the VLOOKUP function is_____

The field or fields selected for sorting records are called ____ keys.

Each row of an Excel worksheet used to create a table can store a record, and each column can store a(n) ____.

If the function references a(n) range that grows or shrinks, Excel automatically adjusts the first argument if the table grows or shrinks

A ____ should be formatted so that the records are easily distinguished

The Conditional Formatting Rules Manager dialog box allows you to change the order in which the rules are applied to a cell or range.

A table also is called a record

Which of the following is the path to the Format as Table button?

If the criteria range contains a blank row, it means that no comparison criteria have been defined.

Like the AutoFilter query technique, the ____ command displays a subset of the table.

With criteria ranges, if you want an AND operator on two different fields, your criteria range must contain two (or more) data rows.

A table can have a maximum of 16,384 fields and 1,048,576 records.

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 ____.

Placing more than one table on the same worksheet is recommended.

You can click the arrow to the right side of a cell in the total row to display a list of available statistical functions.

You can apply merge and center formatting with the Center button (HOME tab | Alignment group).

In a multiple-field filter operation, the AND and OR options are interchangeable

If the table column you choose to sort contains numeric data, the Sort & Filter menu shows the Sort Smallest to Largest and Sort Largest to Smallest commands.

The path to the Percent Style button is (HOME tab | Editing group).

Excel includes ____ database functions that allow you to evaluate numeric data in a table.

When you select a second filter criterion in a table, Excel turns off all previously selected filter criteria.

The most common subtotal uses the ____ function.

Which of the following is NOT a type of conditional formatting?

Both the HLOOKUP and VLOOKUP functions look up a value in a table and return a corresponding value from the table to the cell containing the function.

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.

Why is the VLOOKUP function used more often than other lookup functions?

The DAVERAGE function requires a numeric field from the table range.

The VLOOKUP function uses the left column of the ____ to compare against a particular number in the main table

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 click ____ on the Table submenu.

____ causes adjacent rows to have different formatting so that each row in the table is distinguished from surrounding rows.

In a table, or database, the data related to each person or item is called a ____.

The Conditional Formatting ____ dialog box displays all of the rules for the current selection or for the entire workbook.

A worksheet's row-and-column structure can be used to organize and store a ____.

Database is the name most often assigned to a table.

The VLOOKUP and HLOOKUP functions provide greater flexibility than the MATCH and INDEX functions.

You can set up a criteria range on the worksheet and use it to manipulate formulas that pass the comparison criteria.

The left column values in a table array are called table ____.

You can insert a ____ at the bottom of a table.

The process of filtering activity based on one or more filter criteria is called a ____.

Which of the following is the path to the Total Row check box?

____ 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.

The ____ function is useful when you want to add values in a range only if they meet criteria

Data in descending sequence is sorted from lowest to highest, earlier to most recent, or alphabetically from A to Z

The comparison criteria in the ____ range determine the records that will pass the test when the Advanced Filter dialog box is used

____ is extremely useful for making large tables more manageable in size and appearance

The ____ function is used when the table direction is horizontal

Which of the following is the path to the 'Sort & Filter' button?

Data is in ____ sequence if it is in order from lowest to highest

___ records allows you to pull data from a table so that you can analyze or manipulate the data further.

When a table is active, the FORMAT tab on the Ribbon provides powerful commands that allow you to alter the appearance and contents of a table quickly

When you first create a table, Excel automatically enables_____

The DCOUNT function can count either numeric fields or text fields.

A ____ total sums all of the data in a row or column

To remove a filter criterion for a single field, select the Select All option from the column heading AutoFilter menu for that field

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

If you deselect an item from the filter menu, it is called the filter

Excel allows you to sort on a maximum of 400 fields in a single sort operation

A list of all the values that occur in the selected column appear in the AutoFilter menu