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.
A ____ is an organized collection of data.
 A: database
 B: function
 C: formula
 D: filter
2.
Data is in ____ sequence if it is in order from lowest to highest.
 A: key
 B: ascending
 C: descending
 D: loop
3.
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
4.
Displaying ____ is a powerful tool for summarizing data in a table.
 A: moat cells
 B: functions
 C: control ranges
 D: automatic subtotals
5.
Excel includes which of the following conditional formats?
 A: Data bars
 B: Icon sets
 C: Top and bottom rules
 D: All of the above
6.
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
7.
The ____ function is used when the table direction is down the worksheet.
 A: ACROSS
 B: DOWN
 C: VLOOKUP
 D: HLOOKUP
8.
The ____ operator indicates that one of two criteria must be true.
 A: OR
 B: AND
 C: NOR
 D: ALL
9.
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
10.
The item you deselect from the AutoFilter menu is called the ____.
 A: minor sort key
 B: drop item
 C: primary key
 D: filter criterion
11.
In Excel, you can ____.
 A: create a table
 B: create forms and reports
 C: sort data in a table
 D: all of the above
12.
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
13.
The individual data items that make up a record are called ____.
 A: headings
 B: fields
 C: structures
 D: cells
14.
Data is in ____ sequence if it is in order from highest to lowest.
 A: key
 B: ascending
 C: descending
 D: loop
15.
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
16.
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
17.
____ 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
18.
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
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.