Exam 7: Creating, Sorting, and Querying a Table

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.

Case 6-1 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. -You tell Jane that if she ____, then she can easily add and delete product records, change the values of fields in records, sort the records in a different order, determine subtotals for numeric fields, display records that meet comparison criteria, and analyze data using database functions.

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

Excel includes ____________________ types of conditional formats.

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

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

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

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

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

The most common subtotal uses the ____ function.

You can insert a ____ at the bottom of a table.

Database is the name most often assigned to a table.

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

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.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Counts the number of numeric entries in a table field that pass a test.

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

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

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

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.

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