Exam 7: Creating, Sorting, and Querying a Table

MATCHING Identify the letter of the choice that best matches the phrase or definition. -An area of the worksheet that you use to manipulate records that pass the comparison criteria.

Case 6-2 Dan is manipulating data in a table containing records on computer equipment purchases for the past year. Each record in the table contains the date purchased, the type of computer equipment, the vendor's name, the cost of the equipment, and the department in which the equipment is installed. The records were originally entered in order by month of purchase. Dan sends you an e-mail asking how he can rearrange the table's records to see all the purchases from each vendor in date order within each department. He also wants to know a quick way to get the data back into its original order, whenever necessary. -To rearrange the data, you suggest that Dan create a custom sort by setting the ____.

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

Each ____________________ in any given table column should have similar data.

The left column values in a table array are called table ____.

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

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

A(n) ____________________ total sums all of the data in a row or column.

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

When you select a second filter criterion in a table, Excel turns off all previously selected filter criteria.

If the function references a(n) range that grows or shrinks, Excel automatically adjusts the first argument if the table grows or shrinks.

You can sort data in a table by tapping or clicking the Sort A to Z button in the Sort & Filter group on the ____________________ tab.