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:

Atomic Symbol

A one- or two-letter notation used to represent an element, based on its Latin name.

Copper

A red-orange metallic element that is ductile and conductive, used extensively in electrical wiring and plumbing.

Atomic Symbol

A one or two-letter notation representing a chemical element (e.g., H for hydrogen, O for oxygen) based on its name, often derived from Latin.