Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
Which of the following displays and hides the
formulas on a worksheet?
a. | CTRL + ‘ | c. | ALT + ~ | b. | CTRL +` | d. | ALT + ` |
|
|
|
2.
|
What is the second argument of the LOOKUP function?
a. | the LOOKUP table | c. | the row or column in the LOOKUP table that contains the
value | b. | the value in the worksheet you are looking for | d. | the database |
|
|
|
3.
|
How do you performa a What-if Analysis?
a. | Create a PivotChart | c. | trace errors | b. | group and outline data | d. | compare
scenarios |
|
|
|
4.
|
What does the SUMIFS function do?
a. | returns the average of cells in a range that meet criteria | c. | adds values in a
range based on multiple conditions | b. | adds all numbers in a range of cell, based on a
given criteria | d. | averages
cells that meet multiple criteria |
|
Matching
|
|
|
a. | Argument | i. | PROPER | b. | Conditional Logic | j. | Scenario | c. | Constraint | k. | SUBSTITUTE | d. | Criteria | l. | UPPER | e. | Database
Function | m. | What-If
Analysis | f. | LOWER | n. | Generate | g. | Pivot Chart | o. | Locate | h. | Pivot
Table |
|
|
|
5.
|
Changes that are made to the appearance of a cell
or cell range only if it meets certain conditions.
|
|
|
6.
|
A formula that acts only on those items that meet
certain criteria or conditions.
|
|
|
7.
|
A chart of data created from a
PivotTable.
|
|
|
8.
|
A function that changes text to
lowercase.
|
|
|
9.
|
A function that allows the user to exchange one
word for another quickly.,
|
|
|
10.
|
An item that meets certain criteria set by the
user.
|
|
|
11.
|
Conditions
|
|
|
12.
|
A tool that creates a concise report summarizing
large amounts of data based on ranges selected by the user.,
|
|
|
13.
|
Find.
|
|
|
14.
|
Create
|
|
|
15.
|
A test of outcomes for each possible
situation
|
|
|
16.
|
Limit.
|
|
|
17.
|
A function that makes the text
uppercase.
|
|
|
18.
|
A version of the data that the user saves and
names
|
|
|
19.
|
A function that makes only the first letter
uppercase.
|