True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
The Concatenate function breaks a text string into separate strings.
|
|
|
2.
|
A delimiter is a data separator.
|
|
|
3.
|
You can assign names to cells and ranges, but you cannot use these names in
formulas.
|
|
|
4.
|
You must type underscores instead of spaces between words when you assign a name
to a cell or range.
|
|
|
5.
|
The Name Manager can be used to create a worksheet name.
|
|
|
6.
|
The # (number symbol) is an external reference indicator.
|
|
|
7.
|
Data can be consolidated from different worksheets.
|
|
|
8.
|
If a number is divided by zero the error value #DIV/0! will display in the
cell.
|
|
|
9.
|
If a value in a formula is not available the error value #NA will display in the
cell.
|
|
|
10.
|
If a number is invalidly used in a formula the error value #NV will display in
the cell.
|
|
|
11.
|
The parts of an IF function are separated by parentheses.
|
|
|
12.
|
You can build a logical formula using an IF function.
|
|
|
13.
|
Symbols, such as less than (<), greater than (>), and equal to (=), are
all examples of comparison operators.
|
|
|
14.
|
If there are invalid cell references in a formula the error value #REF! will
display in the cell.
|
|
|
15.
|
The AND function returns a value of TRUE if every logical text in the formula is
true.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
16.
|
Determine the calculated result of the formula =PROPER(john smith).
a. | JOHN SMITH | c. | john smith | b. | John Smith | d. | John smith |
|
|
|
17.
|
Which Excel feature is used to break a data field into separate columns?
a. | Break | c. | Convert Text to Columns | b. | Separate | d. | Proper |
|
|
|
18.
|
Which text function converts text to lowercase?
a. | Upper | c. | Proper | b. | Lower | d. | And |
|
|
|
19.
|
Which text function converts text to uppercase?
a. | Upper | c. | Proper | b. | Lower | d. | Or |
|
|
|
20.
|
Which of the following statements about using names in formulas is NOT
true?
a. | Names make formulas easy to recognize and maintain. | b. | You can assign names
to cells and ranges. | c. | Names are only displayed in Formula
View. | d. | You can use cell and range names in formulas. |
|
|
|
21.
|
Which function allows you to total a range with multiple criteria?
a. | SUMIF | c. | COUNTIF | b. | SUMIFS | d. | COUNTIFS |
|
|
|
22.
|
Which error code will display if a value in a formula is not available?
a. | #NAME? | c. | #NONE | b. | #VAL | d. | #NA |
|
|
|
23.
|
Which error code will display if a column is not wide enough to display
data?
a. | #### | c. | #NULL! | b. | #NUM! | d. | #NA |
|
|
|
24.
|
A formula that makes calculations based on stated conditions is called a
a. | Logical formula. | c. | Logical test. | b. | Conditional test. | d. | Comparison
formula. |
|
|
|
25.
|
Which of these is NOT one of the three parts of an IF function?
a. | A logical test. | c. | An action to take if the condition is true. | b. | A what-if
analysis. | d. | An action to take
if the condition is false. |
|
|
|
|
|
|
26.
|
In the figure above, which numbered item identifies the logical test?
|
|
|
|
|
|
27.
|
In the figure above, which button do you click to filter the workbook
names?
|
|
|
28.
|
In the figure above, which button do you click to create a workbook
name?
|
|
|
29.
|
Which of the following is NOT one of the parts of a PMT function?
|
|
|
|
|
|
30.
|
In the figure above, the interest rate is expressed as:
a. | Bimonthly | c. | Quarterly | b. | Monthly | d. | Annual. |
|