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