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:

Social Situation

The immediate physical and social setting in which people are involved that influences their thoughts, feelings, and behaviors.

Research Designs

Systematic plans used by researchers to gather, measure, and analyze data for a study.

Basic Features

Fundamental attributes or characteristics that define objects, concepts, or systems.

Types

Categories or classes into which people, objects, or phenomena are grouped based on shared characteristics.