Use the Data Given Below to Answer the Following Questions)

question 18

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}$
-Which of the following Database functions calculates the average item cost ordered by Rex Technologies?

• A) =DAVERAGEA3:H10,C3,A12:A13)
• B) =DAVERAGEA3:H10,C3,A12:B13)
• C) =DAVERAGEA3:H10,"Item Cost",A12:A14)
• D) =DSUMA3:H10,C3,A12:A13)/COUNTAA4:A10)

---

Definitions:

Cognitive-Behavioral

Relating to a type of psychotherapy that focuses on changing negative thought patterns and behaviors to improve emotional regulation and develop personal coping strategies.

Social Contacts

Interactions and connections between individuals in social settings, which can influence mental health and well-being.

Avoidant Personality Disorder

A mental health disorder characterized by a pervasive pattern of social inhibition, feelings of inadequacy, and hypersensitivity to negative evaluation.

Dependent Personality Disorder

A mental health condition characterized by pervasive psychological dependence on other people.