Exam 7: Excell: Creating, Sorting, and Querying a Table

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

Excel does not sort ____________________ records.

Modified Multiple Choice Which of the following are database functions?

The ____________________ command on the AutoFilter menu allows you to enter custom criteria, such as multiple options or ranges of numbers.

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

Excel includes ____________________ types of conditional formats.

If the function references a(n) table that changes places on the worksheet, you would have to reenter the function.

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

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.

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

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

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

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

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

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

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

When you enable ____________________ and records are hidden, Excel displays a filter icon in the table column heading arrows used to establish the filter.