Use the Data Given Below to Answer the Following Question(s)

Multiple Choice

Use the data given below to answer the following question(s)
Below is the spreadsheet for demand prediction of a company that sells chocolates. $$\begin{array} { | l | l | l | l | } \hline & \text { A } & \text { B } & \text { C } \\\hline 1 & \text { Demand Prediction } & & \\& \text { Models } & & \\\hline 2 & & & \\\hline 3 & \text { Linear Model } & & \\\hline 4 & \text { A } & 10,000 & \\\hline 5 & \text { 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 a dollar sign is used after the column in B5 (B$5) , how will the formula at B8 be represented in C9 using absolute addressing?

A) C3-B$5*C9
B) C5-C$6*B9
C) C5-C$6*C9
D) C5-C$5*B9