Consider the following MS-EXCEL spreadsheet: A B C D E 1. Item Quantity Price…
2024
Consider the following MS-EXCEL spreadsheet:
A | B | C | D | E | |
|---|---|---|---|---|---|
1. | Item | Quantity | Price | Revenue | |
2. | A–12 | 12 | 5 | 60 | |
3. | B–32 | 31 | 9 | 279 | |
4. | C–44 | 24 | 12 | 288 |
If the formula = $B$2 * $C$2 is entered into cell E2, and the formula is then copied to cells E3 and E4, then the values in cells E2, E3 and E4 will be
Answer: A. 60, 60 and 60, respectively. — ConceptIn a spreadsheet formula, a dollar sign before a column letter locks the column, while a dollar sign before a row number locks the row. A reference…
- A.
60, 60 and 60, respectively.
- B.
60, 279 and 288, respectively
- C.
0, 0 and 0 respectively
- D.
60, 40 and 36, respectively
Attempted by 1 students.
Show answer & explanation
Correct answer: A
Concept
In a spreadsheet formula, a dollar sign before a column letter locks the column, while a dollar sign before a row number locks the row. A reference with both signs is absolute, so copying the formula does not change the referenced cell.
Application
The formula entered in
E2is=$B$2 * $C$2.The references
$B$2and$C$2lock both their columns and rows, so copying the formula toE3andE4leaves both source addresses unchanged.The referenced cells contain
B2 = 12andC2 = 5; therefore each destination evaluates12 × 5 = 60.
Cross-check
At E3 and E4, the copied formula is still =$B$2 * $C$2, confirming the same product in every destination cell.
Result
The values in E2, E3, and E4 are 60, 60, and 60, respectively.