Practice Test Chapter 5
INSTRUCTIONS: Answer each question below. Enter your name and click the 'Grade Test' button to receive a graded study guide. You will not get a grade until all questions are answered.
1.
The field or fields you select to sort the records are called ____.
 A: primary fields
 B: filtered keys
 C: fields
 D: sort keys
2.
When sorting, Excel uses the following order of priority:
 A: numbers, spaces, special characters, text, blanks
 B: special characters, numbers, spaces, text, blanks
 C: blanks, spaces, text, numbers, special characters
 D: numbers, text, special characters, blanks, spaces
3.
The process of filtering activity based on one or more filter criteria is called a ____.
 A: minor
 B: query
 C: merging
 D: primary
4.
The ____ available in the AutoFilter menu allows you to enter custom criteria, such as multiple options or ranges.
 A: Custom Filter command
 B: Options and Ranges button
 C: Criteria command
 D: Custom button
5.
When copying records to another location, the location to where the records are copied is called the ____.
 A: extract range
 B: destination table
 C: Clipboard
 D: home record
6.
The ____ function is useful when you want to sum values in a range only if they meet a criteria.
 A: SUMIF
 B: COUNT
 C: ADDIF
 D: NUMBER
7.
Excel’s ____ function tells you the relative position of an item in a range that matches a specified value in a specific order.
 A: MATCH
 B: POSITION
 C: RANGE
 D: ORDER
8.
By using the ____ features of Excel, you can quickly hide and show detail rows.
 A: range
 B: field
 C: outlining
 D: detail
9.
The individual data items that make up a record are called ____.
 A: headings
 B: fields
 C: structures
 D: cells
10.
After you enter a table into a worksheet, you can use Excel to ____.
 A: add and delete records
 B: sort records
 C: determine subtotals for numeric fields
 D: all of the above
11.
The ____ list in the Modify Table Quick Style dialog box allows you to choose almost any aspect of a table to modify.
 A: Format
 B: Table Elements
 C: Table Aspect
 D: Format All
12.
A ____ column is a column in a table in which each row uses a common formula that references other fields in the table.
 A: formatted
 B: sorted
 C: calculated
 D: banded
13.
The ____ function is used when the table direction is down the worksheet.
 A: ACROSS
 B: DOWN
 C: VLOOKUP
 D: HLOOKUP
14.
You can hide columns by selecting them and then pressing ____.
 A: CTRL+0
 B: ALT+TAB
 C: SHIFT+H
 D: CTRL+SPACEBAR+F4
15.
The Conditional Formatting ____ dialog box allows you to view all of the rules for the current selection or an entire worksheet.
 A: Rules Manager
 B: Wizard
 C: AutoFilter
 D: Gallery
16.
The ____ check box on the Design tab allows you to insert a total row at the bottom of a table.
 A: Sum Column
 B: Total Row
 C: Sum Row
 D: Calculate Row
17.
Data is in ____ sequence if it is in order from lowest to highest.
 A: key
 B: ascending
 C: descending
 D: loop
18.
You can sort data by which of the following?
 A: Sort & Filter button on the Home tab
 B: Sort on the shortcut menu
 C: Sort button on the Data tab
 D: All of the above
19.
Excel allows you to sort on a maximum of ____ fields.
 A: 10
 B: 100
 C: 256
 D: no limit
20.
The item you deselect from the AutoFilter menu is called the ____.
 A: minor sort key
 B: drop item
 C: primary key
 D: filter criterion

Enter your name and click the 'Grade Test' button.