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

question 25

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 before the column label B4 ($B4) , how will the formula at B10 be represented in C11 using absolute addressing?

• A) $B5-C6*B11
• B) $C5-C6*A10
• C) $B4-C5*B11
• D) $A5-C6*B11

---

Definitions:

Producer Surplus

The gap between the minimum amount that sellers are prepared to accept for a product or service and the higher price they actually get.

Consumer Surplus

The deviation between what consumers intend and are able to spend on a good or service compared to their final payment.

Tax

A financial charge or levy imposed by a government on individuals or entities to fund public expenditure, creating government revenue.

Quantity Sold

The total number of units of a product or service purchased by customers over a specified period.