Exam 6: Creating, Sorting, and Querying a Table

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

The most common subtotal uses the ____ function.

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

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

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

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

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

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.

Which of the following is an option to distribute a document electronically?

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 is the path to the Total Row check box?

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

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.

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

When you first create a table,Excel automatically enables ____.

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

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

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.

The general form of the VLOOKUP function is ____.

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