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

question 14

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}$$
-Given that D = a-bP, where D, is demand, "a" and "b," are linear constants, and P, is price, from the below spreadsheet, how will the formula in B9 be represented in Excel using relative addressing?

• A) B4-B5*A9
• B) C5-C6*A10
• C) B4-B5*A10
• D) B5-B6*A10

---

Definitions:

Sureness

The state of being confident in one's abilities, decisions, or beliefs.

Certainty

The state of being sure or confident about something, often without any doubt.

Critical Thinking

The objective analysis and evaluation of an issue in order to form a judgment, often involving discernment, analysis, logic, and reasoning.

Emergent Thinking

A mode of thinking that involves integrating different ideas and information to form novel insights or solutions.