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

question 16

Multiple Choice

Use the data given below to answer the following question(s) .
Below is a spreadsheet of purchase orders for a computer hardware retailer. $\begin{array}{|l|l|l|l|l|l|l|l|l|} \hline&A&B&C&D&E&F&G&H\\\hline & \text { Purchase } \\1 & \text { Orders } \\\hline2\\\hline 3 & \text { Supplier } & \begin{array}{l}\text { Item } \\\text { Description }\end{array} & \begin{array}{l}\text { Item } \\\text { Cost }\end{array} & \text { Quantity } & \begin{array}{l}\text { Cost per } \\\text { Order }\end{array} & \begin{array}{l}\text { A/P Terms } \\\text { (Months) }\end{array} & \begin{array}{l}\text { Order } \\\text { No. }\end{array} & \begin{array}{l}\text { Order } \\\text { Size }\end{array} \\\hline& \text { Rex } & \text { Graphics }\\ 4 & \text { Technologies } & \text { Card } & \$ 89 & 35 & \$ 3115 & 20 & \text { AL123 } & \text { Large } \\\hline & \text { Rex } & & & & & & &\\5 & \text { Technologies } & \text { Monitor } & \$ 150 & 15 & \$ 2250 & 25 & \text { AL234 } & \text { Small } \\\hline & \text { Rex } & & & & & & &\\6 & \text { Technologies } & \text { Keyboard } & \$ 15 & 40 & \$ 600 & 15 & \text { AL345 } & \text { Large } \\\hline & \text { Rex } & & & & & & &\\ 7 &\text { Technologies}& \text { Speakers }&\$ 15 & 20 & \$ 300 & 25 & \text { AL456 } & \text { Small } \\\hline & \text { Rex } \\8&\text { Wavetech } & \text { HD Cables } & \$ 5 & 10 & \$ 50 & 25 & \text { KO876 } & \text { Small } \\\hline &\text { Max's } & & & & & & &\\9&\text { Wavetech } & \text { Processor } & \$ 278 & 27 & \$ 6950 & 30 & \text { KO765 } & \text { Large } \\\hline& \text { Max's } & & & & & &\\10&\text { Wavetech } & \text { Hard disk } & \$ 120 & 18 & \$ 2160 & 20 & \text { KO654 } & \text { Small }\\\hline 11 & \\\hline 12 & \\\hline\end{array}$
-To find the largest quantity of items ordered from Rex Technologies, what Excel formula should be used in A12?

• A) =COUNTIF(D4:D10)
• B) =SUM(D4:D7)
• C) =MAX(D4:D7)
• D) =COUNT(D4:D7)

---

Definitions:

Discharge Planning

The process in healthcare settings aimed at planning for a patient's needs after they leave the hospital or medical facility.

Physical Disabilities

Limitations on a person's physical functioning, mobility, dexterity or stamina, often resulting from congenital conditions, illnesses, or injuries.

Adaptive Coping

Strategies that are effectively used to manage stressful situations or emotions, leading to positive outcomes.

Independence

The state of being self-reliant and not dependent on others for support or aid.