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 ____ function is used when the table direction is across the worksheet.
 A: ACROSS
 B: ALOOKUP
 C: VLOOKUP
 D: HLOOKUP
2.
You can use the ____ to create a series in a table.
 A: fill handle
 B: drag and drop method
 C: Merge and Center button
 D: Go Series command
3.
Displaying ____ is a powerful tool for summarizing data in a table.
 A: moat cells
 B: functions
 C: control ranges
 D: automatic subtotals
4.
The ____ function is used when the table direction is down the worksheet.
 A: ACROSS
 B: DOWN
 C: VLOOKUP
 D: HLOOKUP
5.
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
6.
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
7.
To change an active table back to a normal range of cells, point to Table on a shortcut menu, and then click ____ on the Table submenu.
 A: Convert to Range
 B: Revert Table
 C: Undo Table
 D: Make Range
8.
Excel allows you to sort on a maximum of ____ fields.
 A: 10
 B: 100
 C: 256
 D: no limit
9.
By using the ____ features of Excel, you can quickly hide and show detail rows.
 A: range
 B: field
 C: outlining
 D: detail
10.
A value being looked up outside the range of the table causes the VLOOKUP function to return an error message ____ to the cell.
 A: ***********
 B: #N/A
 C: @@@@@@@
 D: error
11.
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
12.
A database is also called a ____.
 A: field
 B: record
 C: table
 D: column
13.
You can hide columns by selecting them and then pressing ____.
 A: CTRL+0
 B: ALT+TAB
 C: SHIFT+H
 D: CTRL+SPACEBAR+F4
14.
The process of filtering activity based on one or more filter criteria is called a ____.
 A: minor
 B: query
 C: merging
 D: primary
15.
A ____ is an organized collection of data.
 A: database
 B: function
 C: formula
 D: filter
16.
Excel includes which of the following conditional formats?
 A: Data bars
 B: Icon sets
 C: Top and bottom rules
 D: All of the above
17.
The item you deselect from the AutoFilter menu is called the ____.
 A: minor sort key
 B: drop item
 C: primary key
 D: filter criterion
18.
The individual data items that make up a record are called ____.
 A: headings
 B: fields
 C: structures
 D: cells
19.
____ formatting allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell.
 A: Object
 B: Conditional
 C: Banded
 D: Filtered
20.
The query technique that uses the column heading arrows is called ____.
 A: HeadingQuery
 B: ColumnFilter
 C: AutoFilter
 D: QueryMaster

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