If, in the spreadsheet, cells B9 and B10 were empty, which of the following formulas should be entered in B8 so that the formula can be dragged to B9 and B10 to obtain their correct values?
A) B4-B5*A8
B) B4-B5*$A8
C) $B4-B5*$A8
D) $B$4-$B$5*$A8

Question

Quizplus · Accepted Answer

The formula should be an absolute reference to cell B4 and an absolute reference to cell B5, so that when the formula is dragged to B9 and B10, the references to B4 and B5 do not change.

If, in the Spreadsheet, Cells B9 and B10 Were Empty