Solved

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

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions