Exam 7: Excell: Creating, Sorting, and Querying a Table

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.

Critical Thinking Questions 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 _____.

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

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

Individual data items that make up a record are called ____________________.

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

Briefly explain how to search a table using AutoFilter.

When creating a table, place ____________________ in the first row of the table.

Using a(n) ____________________ sometimes is faster than entering criteria through the AutoFilter system because once it is established, you do not have to access any menus or dialog boxes to perform the query.

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

The ____ function is useful when you want to add values in a range only if they meet criteria.

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

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

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

The general form of the VLOOKUP function is ____.

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

A table also is called a record.

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

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