Violet Is Learning How to Use the MATCH Function and Is

question 33

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.
-The Sales department has been mistakenly writing the word "return" in the quantity field for orders that are returned. Violet looks at the chart above and can see that the word "return" is not listed this time. However, to check for this word in future orders, Violet writes the formula ____.

• A) =MATCH("return",A1:E1,0)
• B) =MATCH(return,A1:E1,0)
• C) =MATCH(A1:E1,0,"return")
• D) =MATCH("return",0:1000,0)

---

Definitions:

Dominated

Being controlled or heavily influenced by someone or something, often to a disadvantage.

Case Study Method

An instructional strategy that uses real or simulated scenarios for learners to analyze and learn from, typically involving detailed examination of a particular case.

Realistic

Pertains to representing or being in accordance with the external world and the actual experience; practical and feasible.

Critical Thinking

The goal of critically examining and assessing a matter to reach a conclusion.