Use the data given below to answer the following questions) Below is the spreadsheet for demand prediction of a company that sells chocolates. -7) If, in the spreadsheet, cells B9 and

Use the data given below to answer the following questions)
Below is the spreadsheet for demand prediction of a company that sells chocolates.
-7) 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

Leave a Reply

Your email address will not be published.