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 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
2.
The ____ function is used when the table direction is across the worksheet.
 A: ACROSS
 B: ALOOKUP
 C: VLOOKUP
 D: HLOOKUP
3.
The ____ operator indicates that both parts of the criteria must be true.
 A: OR
 B: AND
 C: NOR
 D: BOTH
4.
In Excel, you can ____.
 A: create a table
 B: create forms and reports
 C: sort data in a table
 D: all of the above
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.
____ columns provide alternating colors every other column.
 A: Conditional
 B: Ascending
 C: Banded
 D: Flashing
7.
By using the ____ features of Excel, you can quickly hide and show detail rows.
 A: range
 B: field
 C: outlining
 D: detail
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 used to count the number of numeric entries in a table field that pass a test.
 A: DNUMBER
 B: DCOUNT
 C: DPASS
 D: DFIELD
10.
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
11.
The item you deselect from the AutoFilter menu is called the ____.
 A: minor sort key
 B: drop item
 C: primary key
 D: filter criterion
12.
A column that contains formulas or functions is called a ____ column.
 A: function
 B: record
 C: calculated
 D: sorted
13.
The field or fields you select to sort the records are called ____.
 A: primary fields
 B: filtered keys
 C: fields
 D: sort keys
14.
Conditional formatting provides which of the following icons?
 A: Arrows
 B: Flags
 C: Traffic signals
 D: All of the above
15.
Excel’s ____ function tells you the relative position of an item in a range that matches a specified value in a specific order.
 A: MATCH
 B: POSITION
 C: RANGE
 D: ORDER
16.
The ____ function is used when the table direction is down the worksheet.
 A: ACROSS
 B: DOWN
 C: VLOOKUP
 D: HLOOKUP
17.
The ____ operator indicates that one of two criteria must be true.
 A: OR
 B: AND
 C: NOR
 D: ALL
18.
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
19.
Excel allows you to sort on a maximum of ____ fields.
 A: 10
 B: 100
 C: 256
 D: no limit
20.
A database is also called a ____.
 A: field
 B: record
 C: table
 D: column

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