Violet Is Learning How to Use the MATCH Function and Is

question 57

Multiple Choice

Violet is learning how to use the MATCH function and is testing several different formulas. The chart above shows orders for small robot toys from five different customers. The amount "0" in column A is for a customer who changed his mind. Please answer the questions below using the data in the figure above.
-Violet wants to send any orders for 30 toys or fewer to Warehouse 1 to ship out. To do this, she locates the position in the chart where the greatest value does not exceed 30. The formula is ____.

• A) =MATCH(30,A1:E1,0)
• B) =MATCH(30,A1:E1,1)
• C) =MATCH(30>,A1:E1,1)
• D) =MATCH(30<A1:E1,0)

---

Definitions:

Ethical Principle

A foundation of guidelines for making moral decisions, typically used to address questions of fairness, justice, and rights.

Honest

The quality of being fair and truthful; free of deceit.

Possible Harm

The potential for damage, injury, or adverse effects in a situation, necessitating caution or preventive measures.

Benefits of Research

The valuable outcomes of research activities, which may include advancements in knowledge, societal improvements, and technological progress.