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:

Risk Factors

Elements or circumstances that increase the likelihood of a negative outcome, such as disease or injury.

Protective Factors

Conditions or attributes in individuals, families, communities, or the larger society that help people deal effectively with stressful events and mitigate or eliminate risk.

Psychological Disorders

Conditions characterized by abnormal thoughts, feelings, or behaviors, which may cause significant distress or impairment in functioning.

Generalized Anxiety Disorder

A mental health disorder characterized by persistent and excessive worry about a number of different things.