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 individual data items that make up a record are called ____.
 A: headings
 B: fields
 C: structures
 D: cells
2.
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
3.
In Excel, you can ____.
 A: create a table
 B: create forms and reports
 C: sort data in a table
 D: all of the above
4.
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
5.
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
6.
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
7.
The ____ function is used when the table direction is down the worksheet.
 A: ACROSS
 B: DOWN
 C: VLOOKUP
 D: HLOOKUP
8.
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
9.
Excel includes which of the following conditional formats?
 A: Data bars
 B: Icon sets
 C: Top and bottom rules
 D: All of the above
10.
The ____ function returns the value or reference of the cell at the intersection of a particular row and column in a table or range.
 A: INDEX
 B: CELL
 C: RANGE
 D: FIELD
11.
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
12.
By using the ____ features of Excel, you can quickly hide and show detail rows.
 A: range
 B: field
 C: outlining
 D: detail
13.
Data is in ____ sequence if it is in order from lowest to highest.
 A: key
 B: ascending
 C: descending
 D: loop
14.
A column that contains formulas or functions is called a ____ column.
 A: function
 B: record
 C: calculated
 D: sorted
15.
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
16.
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
17.
The process of filtering activity based on one or more filter criteria is called a ____.
 A: minor
 B: query
 C: merging
 D: primary
18.
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
19.
The ____ operator indicates that both parts of the criteria must be true.
 A: OR
 B: AND
 C: NOR
 D: BOTH
20.
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

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