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.
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
3.
Excel allows you to sort on a maximum of ____ fields.
 A: 10
 B: 100
 C: 256
 D: no limit
4.
Row ____ causes adjacent rows to have different formatting so that each row in the table is distinguished from surrounding rows.
 A: coding
 B: stepping
 C: pressing
 D: banding
5.
The query technique that uses the column heading arrows is called ____.
 A: HeadingQuery
 B: ColumnFilter
 C: AutoFilter
 D: QueryMaster
6.
The ____ function is used when the table direction is across the worksheet.
 A: ACROSS
 B: ALOOKUP
 C: VLOOKUP
 D: HLOOKUP
7.
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
8.
You can hide columns by selecting them and then pressing ____.
 A: CTRL+0
 B: ALT+TAB
 C: SHIFT+H
 D: CTRL+SPACEBAR+F4
9.
The ____ function is useful when you want to count values in a range only if they meet a criteria.
 A: SUMIF
 B: COUNTIF
 C: ADDIF
 D: NUMBER
10.
Conditional formatting provides which of the following icons?
 A: Arrows
 B: Flags
 C: Traffic signals
 D: All of the above
11.
The field on which you sort prior to clicking the Subtotal button is called the ____.
 A: primary key
 B: control field
 C: merge range
 D: minor key
12.
Arranging records in a specific order is called ____.
 A: sorting
 B: formatting
 C: encoding
 D: merging
13.
The individual data items that make up a record are called ____.
 A: headings
 B: fields
 C: structures
 D: cells
14.
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
15.
In Excel, you can ____.
 A: create a table
 B: create forms and reports
 C: sort data in a table
 D: all of the above
16.
When sorting, you can return records to their original order by clicking the ____ on the Quick Access Toolbar.
 A:  Undo button
 B:  Revert button
 C: Exit No Save button
 D: AutoFilter button
17.
When you have finished typing data for a record and wish to start a new record, press the ____ key.
 A: TAB
 B: right arrow
 C: ENTER
 D: down arrow
18.
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
19.
The ____ function is used when the table direction is down the worksheet.
 A: ACROSS
 B: DOWN
 C: VLOOKUP
 D: HLOOKUP
20.
The ____ function is used to find the average of numbers in a table field that pass a test.
 A: DAVERAGE
 B: DCOUNT
 C: DPASS
 D: DFIELD

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