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:

Collaborative Consumption Services

A business model that involves sharing access to goods or services rather than owning them outright, often facilitated by technology.

Higher Pay

Compensation that is above the average or expected amount for a job, often used as an incentive to attract or retain employees.

Flexible Hours

Work arrangements allowing employees to vary their start and end times, providing greater control over personal schedules.

Filter Bubbles

A phenomenon where an individual's exposure to information on the internet is limited by algorithms to only what aligns with their past behavior and preferences.