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.
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
2.
The item you deselect from the AutoFilter menu is called the ____.
 A: minor sort key
 B: drop item
 C: primary key
 D: filter criterion
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.
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
5.
A ____ is an organized collection of data.
 A: database
 B: function
 C: formula
 D: filter
6.
In Excel, you can ____.
 A: create a table
 B: create forms and reports
 C: sort data in a table
 D: all of the above
7.
A ____ column is a column in a table in which each row uses a common formula that references other fields in the table.
 A: formatted
 B: sorted
 C: calculated
 D: banded
8.
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
9.
Conditional formatting provides which of the following icons?
 A: Arrows
 B: Flags
 C: Traffic signals
 D: All of the above
10.
Data is in ____ sequence if it is in order from lowest to highest.
 A: key
 B: ascending
 C: descending
 D: loop
11.
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
12.
The query technique that uses the column heading arrows is called ____.
 A: HeadingQuery
 B: ColumnFilter
 C: AutoFilter
 D: QueryMaster
13.
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
14.
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
15.
The individual data items that make up a record are called ____.
 A: headings
 B: fields
 C: structures
 D: cells
16.
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
17.
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: *
18.
You can hide columns by selecting them and then pressing ____.
 A: CTRL+0
 B: ALT+TAB
 C: SHIFT+H
 D: CTRL+SPACEBAR+F4
19.
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
20.
Data is in ____ sequence if it is in order from highest to lowest.
 A: key
 B: ascending
 C: descending
 D: loop

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