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

question 25

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 before the column label B4 ($B4) , how will the formula at B10 be represented in C11 using absolute addressing?

• A) $B5-C6*B11
• B) $C5-C6*A10
• C) $B4-C5*B11
• D) $A5-C6*B11

---

Definitions:

Masking Stimulus

A stimulus that interferes with the perception of another stimulus, often used in psychological experiments to test sensory thresholds or attention.

Priming

The process by which recent experiences increase the accessibility of a schema, trait, or concept, influencing responses.

Weber's Law

A principle in psychology stating that the smallest perceptible change in a stimulus is proportional to the magnitude of the original stimulus.

Subliminal Audio

Audio stimuli played below the conscious threshold of hearing, designed to influence behavior or emotions without the listener's conscious awareness.