In the following spreadsheet, which of the formulae below would be best for…
2022
In the following spreadsheet, which of the formulae below would be best for cell C2? Note that the formula must be able to be copied down from C2 to both C3 and C4.
A | B | C | |
|---|---|---|---|
1 | Lunch Cost (Rs.) | Dinner Cost (Rs.) | Total Cost (Rs.) |
2 | 15 | 27 | 42 |
3 | 23 | 35 | 58 |
4 | 10 | 35 | 45 |
Answer: D. = $A2 + $B2 — CONCEPTA spreadsheet reference has a column part and a row part. A dollar sign fixes the part that follows it; without a dollar sign, that part changes when…
- A.
= A$2 + $B2
- B.
= $A$2 + B2
- C.
= $A$2 + $B$2
- D.
= $A2 + $B2
Show answer & explanation
Correct answer: D
CONCEPT
A spreadsheet reference has a column part and a row part. A dollar sign fixes the part that follows it; without a dollar sign, that part changes when the formula is copied.
A copied formula preserves fixed components and shifts relative components by the row or column displacement of the copy.
APPLICATION
The total in column C must add the lunch and dinner values from the same row.
In C2, =$A2+$B2 uses A2 and B2, giving 15+27=42.
When copied to C3, the fixed columns stay A and B while the relative row becomes 3, so the formula becomes =$A3+$B3 and gives 23+35=58.
When copied to C4, the formula becomes =$A4+$B4 and gives 10+35=45.
CROSS-CHECK
The computed totals 42, 58, and 45 match the values shown in column C. Therefore, =$A2+$B2 is the suitable formula.