Exam 6: Creating,sorting,and Querying a Table

Which of the following are database functions?

Which of the following is the path to the Total Row check box?

The DCOUNT function can count either numeric fields or text fields.

Excel does not sort ____________________ records.

Describe how to format a table.

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.

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

The VLOOKUP and HLOOKUP functions provide greater flexibility than the MATCH and INDEX functions.

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

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

Why is the VLOOKUP function used more often than other lookup functions?

In a table,or database,the data related to each person or item is called a ____.

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. -As a quick way to get all the records back into their original order,when necessary,you suggest that before he begins to rearrange the records,Dan should _____.

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

The comparison criteria in the ____ range determine the records that will pass the test when the Advanced Filter dialog box is used.

Jane has a worksheet that contains a large amount of data about company products, and she would like to manipulate the data in a variety of ways. She stops by your office and asks if you have any suggestions on an efficient way to do this. -Next you tell Jane that she can accomplish the task by clicking the _____.

____ causes adjacent rows to have different formatting so that each row in the table is distinguished from surrounding rows.

Excel includes ____ database functions that allow you to evaluate numeric data in a table.

The path to the Percent Style button is (HOME tab | Editing group).

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