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.
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
2.
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
3.
The ____ function is used when the table direction is across the worksheet.
 A: ACROSS
 B: ALOOKUP
 C: VLOOKUP
 D: HLOOKUP
4.
The ____ operator indicates that both parts of the criteria must be true.
 A: OR
 B: AND
 C: NOR
 D: BOTH
5.
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
6.
The query technique that uses the column heading arrows is called ____.
 A: HeadingQuery
 B: ColumnFilter
 C: AutoFilter
 D: QueryMaster
7.
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
8.
The process of filtering activity based on one or more filter criteria is called a ____.
 A: minor
 B: query
 C: merging
 D: primary
9.
A range of blank rows or columns on the side of a table is called a ____.
 A: margin
 B: moat of cells
 C: border
 D: dead column
10.
Excel allows you to sort on a maximum of ____ fields.
 A: 10
 B: 100
 C: 256
 D: no limit
11.
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
12.
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
13.
A column that contains formulas or functions is called a ____ column.
 A: function
 B: record
 C: calculated
 D: sorted
14.
The field or fields you select to sort the records are called ____.
 A: primary fields
 B: filtered keys
 C: fields
 D: sort keys
15.
A ____ is an organized collection of data.
 A: database
 B: function
 C: formula
 D: filter
16.
Data is in ____ sequence if it is in order from lowest to highest.
 A: key
 B: ascending
 C: descending
 D: loop
17.
____ columns provide alternating colors every other column.
 A: Conditional
 B: Ascending
 C: Banded
 D: Flashing
18.
By using the ____ features of Excel, you can quickly hide and show detail rows.
 A: range
 B: field
 C: outlining
 D: detail
19.
When a table is active, the ____ on the Ribbon provides powerful commands that allow you to alter the appearance and contents of a table quickly.
 A: Active tab
 B: Design tab
 C: Format tab
 D: Table Command tab
20.
Displaying ____ is a powerful tool for summarizing data in a table.
 A: moat cells
 B: functions
 C: control ranges
 D: automatic subtotals

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