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.
____ 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
2.
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
3.
The ____ list in the Modify Table Quick Style dialog box allows you to choose almost any aspect of a table to modify.
 A: Format
 B: Table Elements
 C: Table Aspect
 D: Format All
4.
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
5.
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
6.
Displaying ____ is a powerful tool for summarizing data in a table.
 A: moat cells
 B: functions
 C: control ranges
 D: automatic subtotals
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.
The query technique that uses the column heading arrows is called ____.
 A: HeadingQuery
 B: ColumnFilter
 C: AutoFilter
 D: QueryMaster
9.
A database is also called a ____.
 A: field
 B: record
 C: table
 D: column
10.
Arranging records in a specific order is called ____.
 A: sorting
 B: formatting
 C: encoding
 D: merging
11.
The ____ function is used when the table direction is down the worksheet.
 A: ACROSS
 B: DOWN
 C: VLOOKUP
 D: HLOOKUP
12.
The ____ operator indicates that one of two criteria must be true.
 A: OR
 B: AND
 C: NOR
 D: ALL
13.
A column that contains formulas or functions is called a ____ column.
 A: function
 B: record
 C: calculated
 D: sorted
14.
The field or fields you select to sort the records are called ____.
 A: primary fields
 B: filtered keys
 C: fields
 D: sort keys
15.
You can hide columns by selecting them and then pressing ____.
 A: CTRL+0
 B: ALT+TAB
 C: SHIFT+H
 D: CTRL+SPACEBAR+F4
16.
The ____ function is used to count the number of numeric entries in a table field that pass a test.
 A: DNUMBER
 B: DCOUNT
 C: DPASS
 D: DFIELD
17.
In Excel, you can ____.
 A: create a table
 B: create forms and reports
 C: sort data in a table
 D: all of the above
18.
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
19.
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
20.
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

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