Use the data given below to answer the following question(s) Below is the spreadsheet for demand prediction of a company that sells chocolates. B A Demand Prediction Models 1 culler solo 10.000 10 3 Linear Model s B 6 Price 8 S50 9 555 10 $45 11 Demand 9.500 2.450 9.550 If a dollar sign is used before the column label B4 ($B4), how will the formula at B10 be represented in C11 using absolute addressing? a) $B5-C6*B11 Ob) $C5-C6'A10 c) $B4-C5B11 If a dollar sign is used before the column label B4 ($B4), how will the formula at B10 be represented in C11 using absolute addressing? O a) $B5-C6*B11 Ob) $C5-C6*A10 c) $B4-C5*B11 d) $A5-C64B11