Use the Table Below to Answer the Following Questions) -Which of the Following Is the Excel Formula to Determine

question 18

Multiple Choice

Use the table below to answer the following questions) .
In the spreadsheet below, there is data on the price, cost, demand, and quantity produced for an item. There are also different "what if" values that can help a manager to calculate costs and revenue with variability in demand. $$\begin{array} { | l | l | l | l | } \hline & \text { A } & \text { B } & \text { C } \\\hline 1 & \text { Prufit Madel } & & \\\hline 2 & & & \\\hline 3 & & & \text { What } \text { V J Demand } \\ & \text { Data } & & \text { Values } \\\hline 4 & & & 20,000 \\\hline 5 & \text { Unit Price \$) } & 50 & 40,000 \\\hline 6 & \text { Unit Cost \$) } & 25 & 55,000 \\\hline 7& \text { Fixed Cast \$) } & 550,000 & 60,000 \\\hline 8 & \text { Demand } & 60,000 & 65,000 \\\hline 9 & \text { Quantity Praduced } & 55,000 & \\\hline 10 & & & \\\hline\end{array}$$
-Which of the following is the Excel formula to determine the number of units sold?

• A) =B8
• B) =MIN0,B8,B9)
• C) =MINB8,B9)
• D) =MAX0,B8,B9)

---

Definitions:

Plasticity

The brain’s special capacity for change.

Complexity

The state or quality of being intricate or complicated, involving numerous interrelated parts or aspects.

Resting Potential

The stable, negative charge of an inactive neuron.

Polarization

In social psychology, the phenomenon where an individual or group's opinions become more extreme from discussing within a like-minded group. In physics, the orientation of electromagnetic waves or the alignment of charges within a material.