Exam 7: Creating, Sorting, and Querying a Table

A(n) ____________________ is the sum of a subset of data.

Describe how to format a table.

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

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

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

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

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

Which of the following are database functions?

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

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

The general form of the VLOOKUP function is ____.

____ cause(s) adjacent rows or columns to have different formatting so that each row or column in the table is distinguished from the surrounding rows or columns.

____________________ cause(s) adjacent rows to have different formatting.

Using a(n) ____________________ sometimes is faster than entering criteria through the AutoFilter system because once it is established, you do not have to access any menus or dialog boxes to perform the query.

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

The ____ function is used when the table direction is horizontal.

A(n) ____________________ row-and-column structure can be used to organize and store a table or database.

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.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The field or fields you select to sort records.