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.
Excel allows you to sort on a maximum of ____ fields.
A:
10
B:
100
C:
256
D:
no limit
2.
____ columns provide alternating colors every other column.
A:
Conditional
B:
Ascending
C:
Banded
D:
Flashing
3.
By using the ____ features of Excel, you can quickly hide and show detail rows.
A:
range
B:
field
C:
outlining
D:
detail
4.
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
5.
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
6.
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
7.
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
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.
You can hide columns by selecting them and then pressing ____.
A:
CTRL+0
B:
ALT+TAB
C:
SHIFT+H
D:
CTRL+SPACEBAR+F4
11.
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
12.
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
13.
The process of filtering activity based on one or more filter criteria is called a ____.
A:
minor
B:
query
C:
merging
D:
primary
14.
A ____ is an organized collection of data.
A:
database
B:
function
C:
formula
D:
filter
15.
Data is in ____ sequence if it is in order from lowest to highest.
A:
key
B:
ascending
C:
descending
D:
loop
16.
Excel includes which of the following conditional formats?
A:
Data bars
B:
Icon sets
C:
Top and bottom rules
D:
All of the above
17.
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
18.
When you have finished typing data for a record and wish to start a new record, press the ____ key.
A:
TAB
B:
right arrow
C:
ENTER
D:
down arrow
19.
The item you deselect from the AutoFilter menu is called the ____.
A:
minor sort key
B:
drop item
C:
primary key
D:
filter criterion
20.
The individual data items that make up a record are called ____.
A:
headings
B:
fields
C:
structures
D:
cells
Enter your name and click the 'Grade Test' button.