True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
Cell
references that change when copied are called relative cell references.
|
|
|
2.
|
A
function is a predefined formula for a commonly used calculation.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
3.
|
A
source cell is sometimes called a source ____. a. | format | b. | target | c. | destination | d. | range | | |
|
|
|
|
|
|
4.
|
The
small black box you see in the corner of the active cell in Figure 2-19 is called a
____. a. | fill
handle | b. | pull handle | c. | handle | d. | pull box | | |
|
|
|
5.
|
$B6
is an example of a(n) ____ reference. a. | mixed | b. | absolute | c. | relative | d. | dollar | | |
|
|
|
6.
|
To
calculate the total of the cells in the range A1:A100, you would insert the expression ____ into the
active cell. a. | SUM(A1:A100) | b. | TOTAL(A1:A100) | c. | =SUM(A1:A100) | d. | =TOTAL(A1:A100) | | |
|
Completion
Complete each sentence or
statement.
|
|
|
7.
|
Cell
B8 contains the formula =B1+B3. If the contents of B8 are copied to D12, give the resulting
formula ____________________.
|
|
|
8.
|
Write
a formula or function that would add the contents of cells B8 thru B12..
|