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

In a table, a column that contains formulas or functions is called a(n) ____.

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

When performing an advanced filter operation, the location to where the records are copied is called the ____________________ range.

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

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

In the Sort dialog box, shown in the accompanying figure, the ____ is the Sort by field.

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

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.

With the criteria range, if you want a(n) ____________________ operator in the same field name, you must add a column in the criteria range and duplicate the column heading.

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

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