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:

Ambiguous Situations

Scenarios or circumstances that lack clarity and can be interpreted in multiple ways, often leading to uncertainty and confusion in decision making.

Terminal Value

The estimated value of an investment at the end of its life, considering all future cash flows reduced to their present value.

Sense of Accomplishment

A feeling of satisfaction obtained from successfully completing a task or achieving a goal.

Archie B. Carroll

A business academic known for his work on corporate social responsibility and the pyramid model that outlines the four responsibilities of business: economic, legal, ethical, and philanthropic.