Use the data given below to answer the following questions) Below is the spreadsheet for demand prediction of a company that sells chocolates. -4) Given that D = a-bP, where D,

Use the data given below to answer the following questions)
Below is the spreadsheet for demand prediction of a company that sells chocolates.
-4) Given that D = a-bP, where D, is demand, “a” and “b,” are linear constants, and P, is price, from the below spreadsheet, how will the formula in B9 be represented in Excel using relative addressing?
A) B4-B5*A9
B) C5-C6*A10
C) B4-B5*A10
D) B5-B6*A10

Leave a Reply

Your email address will not be published.