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

question 9

Multiple Choice

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