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:

Caloric Needs

The amount of energy, measured in calories, that a person requires to maintain bodily functions and support daily activities.

Overeating

Consumption of more food than the body needs for energy, often leading to weight gain and potentially obesity.

Ovarian Cancer

A type of cancer that begins in the ovaries, which are the female reproductive glands that produce eggs (ova) as well as the hormones estrogen and progesterone.

Infertility

The inability to conceive a child after a year or more of regular sexual intercourse without the use of birth control.