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

question 6

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

---

Definitions:

Shifts to the Right

A phrase indicating an increase in supply or demand in economic graphs, typically showing improvement or growth.

Price Effect

Refers to the impact on consumer demand or the quantity demanded of a good when its price changes, holding other factors constant.

Quantity Effect

The change in total revenue resulting from a change in the quantity of a product sold, holding price constant.

Price Elasticity of Demand

A measure of how much the quantity demanded of a good responds to a change in the price of that good, quantitatively defined as the percentage change in quantity demanded divided by the percentage change in price.