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 query technique that uses the column heading arrows is called ____.
 A: HeadingQuery
 B: ColumnFilter
 C: AutoFilter
 D: QueryMaster
2.
The individual data items that make up a record are called ____.
 A: headings
 B: fields
 C: structures
 D: cells
3.
Data is in ____ sequence if it is in order from highest to lowest.
 A: key
 B: ascending
 C: descending
 D: loop
4.
Excel includes which of the following conditional formats?
 A: Data bars
 B: Icon sets
 C: Top and bottom rules
 D: All of the above
5.
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
6.
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
7.
The process of filtering activity based on one or more filter criteria is called a ____.
 A: minor
 B: query
 C: merging
 D: primary
8.
A database is also called a ____.
 A: field
 B: record
 C: table
 D: column
9.
Arranging records in a specific order is called ____.
 A: sorting
 B: formatting
 C: encoding
 D: merging
10.
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
11.
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
12.
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
13.
Excel allows you to sort on a maximum of ____ fields.
 A: 10
 B: 100
 C: 256
 D: no limit
14.
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
15.
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
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.
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
19.
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
20.
Conditional formatting provides which of the following icons?
 A: Arrows
 B: Flags
 C: Traffic signals
 D: All of the above

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