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:

Musculature

The system of muscles in the body, especially when regarded in terms of their form, structure, and functional abilities.

Proxemics

The study of how humans use space in communication and interaction, including personal distance and territorial behavior.

Occupational Area

A field or sector of work or profession.

Physical Separation

The act of being apart from others in space or distance, which can affect relationships and mental health.