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 down the worksheet.
 A: ACROSS
 B: DOWN
 C: VLOOKUP
 D: HLOOKUP
2.
The ____ operator indicates that one of two criteria must be true.
 A: OR
 B: AND
 C: NOR
 D: ALL
3.
A column that contains formulas or functions is called a ____ column.
 A: function
 B: record
 C: calculated
 D: sorted
4.
The field or fields you select to sort the records are called ____.
 A: primary fields
 B: filtered keys
 C: fields
 D: sort keys
5.
You can hide columns by selecting them and then pressing ____.
 A: CTRL+0
 B: ALT+TAB
 C: SHIFT+H
 D: CTRL+SPACEBAR+F4
6.
The ____ function is used to count the number of numeric entries in a table field that pass a test.
 A: DNUMBER
 B: DCOUNT
 C: DPASS
 D: DFIELD
7.
In Excel, you can ____.
 A: create a table
 B: create forms and reports
 C: sort data in a table
 D: all of the above
8.
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
9.
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
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.
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
12.
The process of filtering activity based on one or more filter criteria is called a ____.
 A: minor
 B: query
 C: merging
 D: primary
13.
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
14.
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
15.
Excel allows you to refer to the column headings in formulas by placing the column heading in brackets and adding ____ to the beginning of the column name.
 A: @
 B: #
 C: $
 D: *
16.
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
17.
A ____ is an organized collection of data.
 A: database
 B: function
 C: formula
 D: filter
18.
Data is in ____ sequence if it is in order from lowest to highest.
 A: key
 B: ascending
 C: descending
 D: loop
19.
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
20.
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

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