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.
The ____ function is useful when you want to sum values in a range only if they meet a criteria.
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
Excel allows you to sort on a maximum of ____ fields.
 A: 10
 B: 100
 C: 256
 D: no limit
Conditional formatting provides which of the following icons?
 A: Arrows
 B: Flags
 C: Traffic signals
 D: All of the above
Excel’s ____ function tells you the relative position of an item in a range that matches a specified value in a specific order.
When you have finished typing data for a record and wish to start a new record, press the ____ key.
 B: right arrow
 D: down arrow
The item you deselect from the AutoFilter menu is called the ____.
 A: minor sort key
 B: drop item
 C: primary key
 D: filter criterion
____ columns provide alternating colors every other column.
 A: Conditional
 B: Ascending
 C: Banded
 D: Flashing
By using the ____ features of Excel, you can quickly hide and show detail rows.
 A: range
 B: field
 C: outlining
 D: detail
The ____ function is used when the table direction is across the worksheet.
The ____ operator indicates that both parts of the criteria must be true.
 A: OR
The individual data items that make up a record are called ____.
 A: headings
 B: fields
 C: structures
 D: cells
Data is in ____ sequence if it is in order from highest to lowest.
 A: key
 B: ascending
 C: descending
 D: loop
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
The ____ function is used to find the average of numbers in a table field that pass a test.
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
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
____ 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
The ____ function is useful when you want to count values in a range only if they meet a criteria.
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.