Exam 6: Creating,sorting,and Querying a Table

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

Database is the name most often assigned to a table.

The most common subtotal uses the ____ function.

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

You can tap or click the arrow to the right side of a cell in the total row to display a list of available statistical functions.

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.

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.

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

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

A worksheet's row-and-column structure can be used to organize and store a ____.

Which of the following are outline symbols?

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

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

With a database function,if one of your arguments is a field name and the field name is text,rather than a cell reference,number,or range,the argument must be enclosed in ____.

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.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The location to where records that meet the comparison criteria in the criteria range are copied.

____ records allows you to pull data from a table so that you can analyze or manipulate the data further.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -The process of filtering activity based on one or more filter criteria.