True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
When a formula contains multiple operators, Excel uses standard algebraic rules
to determine which calculation to perform first.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
|
|
|
2.
|
If you were to see ##### in cell B10, the ____ is too small to view the entire
value.
a. | column width | c. | both a. and b. | b. | row height | d. | neither a. nor
b. |
|
|
|
3.
|
In the figure above, the total number of payments can be found as follows:
____
a. | =B4*B6 | c. | =B6*B4 | b. | =B4/B6 | d. | =B6/B4 |
|
|
|
4.
|
Absolute references are marked with a ____.
|
|
|
5.
|
When you copy a formula that contains an absolute reference to a new location,
the reference ____.
a. | is updated automatically | c. | becomes bold | b. | does not
change | d. | has a dotted outline
in its cell |
|
|
|
6.
|
Using AutoFill is ____ than copying and pasting.
a. | slower | c. | safer | b. | faster | d. | riskier |
|
|
|
7.
|
As you drag the fill handle, you will see ____.
a. | the AutoFill Options button flashing | c. | the AutoFill
Wizard | b. | ScreenTips | d. | accents |
|
|
|
8.
|
____ are prewritten formulas.
a. | Templates | c. | Tables | b. | Samples | d. | Functions |
|
|
|
9.
|
Cell B10 contains the formula =B7 * C10, if this formula is copied to D12,
then the formula in D12 will be:
a. | =B7 * E10 | c. | =D9 * E10 | b. | =D9 * E12 | d. | =B9 * C12 |
|
|
|
10.
|
Cell D5 contains =B$6 + $B8, if copied to F7, the formula would be:
a. | =D$8 + $D10 | c. | =D$8 + $B10 | b. | =D$10 + $D10 | d. | =B$8 + $B10 |
|