Consider the following worksheet: A B C D 1 5 10 50 2 15 50 3 20 50 4 Which of…
2022
Consider the following worksheet:
A | B | C | D | |
|---|---|---|---|---|
1 | 5 | 10 | 50 | |
2 | 15 | 50 | ||
3 | 20 | 50 | ||
4 |
Which of the following formulas should be entered into the cell D1 so that when it is copied into the cells D2 and D3, it gives the correct values as shown in the range D1:D3?
Answer: D. $B$1 * $C$1 — CONCEPTA relative spreadsheet reference changes when a formula is copied. A dollar sign before a row number fixes that row, and a dollar sign before a column…
- A.
B1 * $C$1
- B.
$B$1 * C1
- C.
B1 * C1
- D.
$B$1 * $C$1
Attempted by 1 students.
Show answer & explanation
Correct answer: D
CONCEPT
A relative spreadsheet reference changes when a formula is copied. A dollar sign before a row number fixes that row, and a dollar sign before a column letter fixes that column; a fully absolute reference fixes both.
For a downward-only copy, fixing the row alone would be sufficient in principle. Among the formulas offered here, however, only the formula with both cell references fully absolute remains unchanged.
APPLICATION
In D1, the required calculation is B1 × C1 = 5 × 10 = 50.
The entries in D2 and D3 must also use B1 and C1, because their displayed results remain 50.
Writing $B$1 and $C$1 fixes both column letters and row numbers during copying.
Therefore the listed formula $B$1 * $C$1 produces 50 in D1, D2, and D3.
CROSS-CHECK
After copying downward, the formula still reads $B$1 * $C$1 in each destination cell. Substituting 5 and 10 gives 50 every time.
Result: $B$1 * $C$1 is the required formula among the given choices.