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:

Flow Of Control

The order in which individual statements, instructions, or function calls of an imperative program are executed or evaluated.

Program's Statements

The individual instructions in a program, written in a programming language, that specify the actions to be performed.

Boolean Operator

A logical operator that performs operations, such as AND, OR, and NOT, on boolean values and produces a boolean result.