Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
When you use an advanced filter, what happens to the data that does not meet the
criteria you set.
a. | It is displayed dimly. | c. | It is deleted | b. | It is temporarily hidden | d. | Its value is
changed. |
|
|
|
2.
|
What is the total of a group of tiems within a larger set of items?
a. | Subtotal | c. | AutoSum | b. | Grand Total | d. | Total |
|
|
|
3.
|
Which of the following tools identifies inaccurate data?
a. | Data Validation | c. | Circle Invalid Data | b. | Group and Outline Data. | d. | Evaluate Formula
|
|
|
|
4.
|
What does Evaluate Formula do?
a. | Points to possible sources of an error. | c. | Steps through a
calculation | b. | Displays tracer arrows | d. | Displays an explanation of an error. |
|
|
|
5.
|
Which of the following hot key commnds will move you down one screen?
a. | CTRL + Page UP | c. | CTRL + Page Down | b. | Page Up | d. | Page Down |
|
Matching
|
|
|
a. | Advanced Filter | h. | Subset | b. | Criteria | i. | Subtotal | c. | Data Validation | j. | Convert | d. | Duplicate
Value | k. | Error | e. | Evaluate Formula | l. | Interpret | f. | Name | m. | Sum | g. | Name Manager
|
|
|
|
6.
|
To construe or understand in a particular way
|
|
|
7.
|
When you use an advanced filter, only those items in a range of cells or table
that meet certian ________________ or conditions will be displayed.
|
|
|
8.
|
A(n) _______________ can be used in a formula in the same way as a conventional
cell reference.
|
|
|
9.
|
Where all values in a row are an exact match of
all values in another row
|
|
|
10.
|
A small amount of data selected from a larger amount.
|
|
|
11.
|
The total of a group of items.
|
|
|
12.
|
Change
|
|
|
13.
|
Error-checking tool to locate invalid formulas
|
|
|
14.
|
A filter that specifies multiple criteria for displaying data.
|
|
|
15.
|
A mistake made when entering data, creating formulas etc
|
|
|
16.
|
The sum of a group of items within a larger set of items.
|
|
|
17.
|
Ensuring that data is correct based on specifi c criteria.
|
|
|
18.
|
A tool that finds, modifi es, or deletes the defi ned names used in a
workbook.
|