Use the Data Given Below to Answer the Following Questions)

Use the data given below to answer the following questions)
Below is the spreadsheet for demand prediction of a company that sells chocolates. $$\begin{array} { | l | l | l | l | } \hline & \text { A } & \text { B } & C \\\hline 1 & \text { Demand Predictim } & & \\& \text { Models } & & \\\hline 2 & & & \\\hline 3 & \text { Linear Model } & & \\\hline 4 & \text { A } & 10,000 & \\\hline 5 & B & 10 & \\\hline 6 & & & \\\hline 7 & \text { Price } & \text { Demand } & \\\hline 8 & \$ 50 & 9,500 & \\\hline 9 & \$ 55 & 9,450 & \\\hline 10 & \$ 45 & 9,550 & \\\hline 11 & & & \\\hline\end{array}$$
-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