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 useful when you want to sum values in a range only if they meet a criteria.
 A: SUMIF
 B: COUNT
 C: ADDIF
 D: NUMBER
2.
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
3.
Excel allows you to sort on a maximum of ____ fields.
 A: 10
 B: 100
 C: 256
 D: no limit
4.
Conditional formatting provides which of the following icons?
 A: Arrows
 B: Flags
 C: Traffic signals
 D: All of the above
5.
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
6.
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
7.
The item you deselect from the AutoFilter menu is called the ____.
 A: minor sort key
 B: drop item
 C: primary key
 D: filter criterion
8.
____ columns provide alternating colors every other column.
 A: Conditional
 B: Ascending
 C: Banded
 D: Flashing
9.
By using the ____ features of Excel, you can quickly hide and show detail rows.
 A: range
 B: field
 C: outlining
 D: detail
10.
The ____ function is used when the table direction is across the worksheet.
 A: ACROSS
 B: ALOOKUP
 C: VLOOKUP
 D: HLOOKUP
11.
The ____ operator indicates that both parts of the criteria must be true.
 A: OR
 B: AND
 C: NOR
 D: BOTH
12.
The individual data items that make up a record are called ____.
 A: headings
 B: fields
 C: structures
 D: cells
13.
Data is in ____ sequence if it is in order from highest to lowest.
 A: key
 B: ascending
 C: descending
 D: loop
14.
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
15.
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
16.
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
17.
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
18.
____ 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
19.
The ____ function is useful when you want to count values in a range only if they meet a criteria.
 A: SUMIF
 B: COUNTIF
 C: ADDIF
 D: NUMBER
20.
The ____ list in the Modify Table Quick Style dialog box allows you to choose almost any aspect of a table to modify.
 A: Format
 B: Table Elements
 C: Table Aspect
 D: Format All

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