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:

Situational Influences

Factors in the environment or context that impact decisions, behaviors, and outcomes.

Ethical People

Pertains to individuals who consistently demonstrate morals and values in their decision-making and behaviors.

Ethically Marginal

Situations or practices that are on the border of being considered right or wrong, often challenging moral or ethical boundaries.

Marginally Ethical

Actions or decisions that skirt the boundaries of moral or ethical standards, often causing debate over their propriety or integrity.