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

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

____________________ also can be added to a table for averages, sums, and other types of calculations.

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

Describe how to format a table.

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

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

The most common subtotal uses the ____ function.

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

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

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.

You can return sorted records to their original order by clicking the ____________________ button on the Quick Access Toolbar.

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.

Database is the name most often assigned to a table.

Modified Multiple Choice Which of the following are outline symbols?

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

The ____________________ function will count the number of numeric entries in a table field that pass a test.

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

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

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