Use the Data Given Below to Answer the Following Questions)

question 4

Multiple Choice

Use the data given below to answer the following questions) .
Below is a spreadsheet of purchase orders for a computer hardware retailer. $\begin{array}{|l|l|l|l|l|l|l|l|l|}\hline& \text { A } & \text { B } & C & \mathrm{D}&E&F&G&H \\\hline &\text { Purchase } & & & \\1& \text { Orders } & & & \\\hline 2\\\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 { AP 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 & \text { \$3115 } & 20 & \text { AL123 } & \text { Large } \\\hline5 & \begin{array}{l}\text { Rex } \\\text { Technologies }\end{array}& \text { Monitor } & \$ 150 & 15 & \$ 2250 & 25 & \text { AL234 } & \text { Small } \\\hline6 & \begin{array}{l}\text { Rex } \\\text { Technologies }\end{array}&\text { Keyboard } & \$ 15 & 40 & \$ 600 & 15 & \text { AL345 } & \text { Large } \\\hline7 & \begin{array}{l}\text { Rex } \\\text { Technologies }\end{array}&\text { Speakers } & \$ 15 & 20 & \$ 300 & 25 & \text { AL456 } & \text { Small } \\\hline8 & \begin{array}{l}\text { Max's } \\\text { wavetech }\end{array}&\text { HD Cables } & \$ 5 & 10 & \$ 50 & 25 & \text { KO876 } & \text { Small } \\\hline9 & \begin{array}{l}\text { Max's } \\\text { wavetech }\end{array}&\text { Processor } & \$ 278 & 27 & \$ 6950 & 30 & \text { KO765 } & \text { Large }\\\hline10 & \begin{array}{l}\text { Max's } \\\text { wavetech }\end{array}&\text { Hard disk } & \$ 120 & 18 & \$ 2160 & 20 & \text { KO654 } & \text { Small }\\\hline 11\\\hline12&\text { Supplier }&\text { Order Size }&\begin{array}{l}\text { item } \\\text { cost }\end{array} \\\hline13 &\text { Rex Technologies}&\text { Large } &>15\\\hline 14&\text { Max's Wavetech }\\\hline\end{array}$
-If purchase quantities of 25 units or higher are found to be large orders, and orders less than 25 are considered to be small, what IF function should be entered in H4 to be copied to H5:H10 to calculate each order's size?

• A) =IFD4=AND=OR=25,"Large","Small")
• B) =IFD4<>25,"Small")=ANDD4=25,"Large")
• C) =IFD4=25,"Large")=OR"Small")
• D) =IFD4>=25,"Large","Small")

---

Definitions:

Social Opportunities

Circumstances or events that allow individuals to interact, network, and build relationships within a community or organization.

Accident Prevention

The initiatives and measures implemented to avoid or minimize the occurrence of accidents in the workplace.

Work Schedules

The planned hours that employees are expected to work, which can vary in terms of shift length, timing, and patterns, depending on the organization's operational needs.

Supervision

The act of overseeing and guiding employees or tasks to ensure that activities are carried out effectively and standards are met.