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.
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
2.
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
3.
A column that contains formulas or functions is called a ____ column.
 A: function
 B: record
 C: calculated
 D: sorted
4.
The field or fields you select to sort the records are called ____.
 A: primary fields
 B: filtered keys
 C: fields
 D: sort keys
5.
A ____ is an organized collection of data.
 A: database
 B: function
 C: formula
 D: filter
6.
Data is in ____ sequence if it is in order from lowest to highest.
 A: key
 B: ascending
 C: descending
 D: loop
7.
____ columns provide alternating colors every other column.
 A: Conditional
 B: Ascending
 C: Banded
 D: Flashing
8.
By using the ____ features of Excel, you can quickly hide and show detail rows.
 A: range
 B: field
 C: outlining
 D: detail
9.
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
10.
Displaying ____ is a powerful tool for summarizing data in a table.
 A: moat cells
 B: functions
 C: control ranges
 D: automatic subtotals
11.
The Conditional Formatting ____ dialog box allows you to view all of the rules for the current selection or an entire worksheet.
 A: Rules Manager
 B: Wizard
 C: AutoFilter
 D: Gallery
12.
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
13.
Excel includes which of the following conditional formats?
 A: Data bars
 B: Icon sets
 C: Top and bottom rules
 D: All of the above
14.
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
15.
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
16.
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
17.
The ____ function is used when the table direction is down the worksheet.
 A: ACROSS
 B: DOWN
 C: VLOOKUP
 D: HLOOKUP
18.
The ____ operator indicates that one of two criteria must be true.
 A: OR
 B: AND
 C: NOR
 D: ALL
19.
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: *
20.
The ____ available in the AutoFilter menu allows you to enter custom criteria, such as multiple options or ranges.
 A: Custom Filter command
 B: Options and Ranges button
 C: Criteria command
 D: Custom button

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