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")

Identify the conditions under which a breach of warranty occurs.

Comprehend the rules for construction when express and implied warranties are consistent.

Recognize the Magnuson-Moss Warranty Act requirements for full warranties.

Understand how to effectively disclaim oral and written warranties.

---

Definitions:

Supply-side Economics

An economic theory that advocates reducing taxes and decreasing regulation to stimulate economic growth by increasing supply of goods and services.

Majoritarian Politics

A political philosophy or agenda that asserts the majority's right to make decisions that affect the society, often at the expense of minority opinion or rights.

Types of Taxes

Refers to the various ways in which governments generate revenue from individuals and businesses, including income tax, sales tax, property tax, and more.

Tax Policy

The principles and laws enacted by governments to collect revenues through taxes from individuals and businesses.