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 field or fields you select to sort the records are called ____.
 A: primary fields
 B: filtered keys
 C: fields
 D: sort keys
2.
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
3.
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
4.
Conditional formatting provides which of the following icons?
 A: Arrows
 B: Flags
 C: Traffic signals
 D: All of the above
5.
The individual data items that make up a record are called ____.
 A: headings
 B: fields
 C: structures
 D: cells
6.
When sorting, you can return records to their original order by clicking the ____ on the Quick Access Toolbar.
 A:  Undo button
 B:  Revert button
 C: Exit No Save button
 D: AutoFilter button
7.
The ____ function is used when the table direction is down the worksheet.
 A: ACROSS
 B: DOWN
 C: VLOOKUP
 D: HLOOKUP
8.
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
9.
Data is in ____ sequence if it is in order from lowest to highest.
 A: key
 B: ascending
 C: descending
 D: loop
10.
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
11.
The ____ operator indicates that both parts of the criteria must be true.
 A: OR
 B: AND
 C: NOR
 D: BOTH
12.
____ 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
13.
A database is also called a ____.
 A: field
 B: record
 C: table
 D: column
14.
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
15.
Excel allows you to refer to the column headings in formulas by placing the column heading in brackets and adding ____ to the beginning of the column name.
 A: @
 B: #
 C: $
 D: *
16.
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
17.
____ columns provide alternating colors every other column.
 A: Conditional
 B: Ascending
 C: Banded
 D: Flashing
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.
The query technique that uses the column heading arrows is called ____.
 A: HeadingQuery
 B: ColumnFilter
 C: AutoFilter
 D: QueryMaster
20.
You can hide columns by selecting them and then pressing ____.
 A: CTRL+0
 B: ALT+TAB
 C: SHIFT+H
 D: CTRL+SPACEBAR+F4

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