Use the data given below to answer the following question

Below is the spreadsheet for demand prediction of a company that sells chocolates.

A

B

C

$1$

Demand Prediction Models

$2$

$3$

Linear Model

$4$

A

$10,000$

$5$

B

$10$

$6$

$7$

Price

Demand

$8$

$$50$

$9,500$

$9$

$$55$

$9,450$

$10$

$$45$

$9,550$

$11$

If a dollar sign is used before the column label B$4($$B$4),$ how will the formula at B$10$ be represented in C$11$ using absolute addressing?

Question $25$ options:

$1)$

$B$5-$C$6*$B$11$

$2)$

$C$5-$C$6*$A$10$

$3)$

$B$4-$C$5*$B$11$

$4)$

$A$5-$C$6*$B$11$