A correct formula to compute the revenue in cell D2 is
A. =$B2*$C2
B. =$B$2*$C$2
C. =B2*C2
D. All of the above,
Consider the following Excel spreadsheet.
A
B
C
D
E
1
SKU Quantity
Price Revenue
2
A-11
12
5
60
3
B-32
31
9
279
4
C-44
24
12
288
If formula =$B$2*$C$2 is entered in cell D2 and the formula is copied down to cells to cell D3 and D4, the result
in cells D2, D3, and D4 should be
respectively.
A. 0, 0, 0
B. 60, 60, 60
C. 60, 279, 288
D. None of the above
Consider the following Excel spreadsheet.