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)

Question

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)

Quizplus · Accepted Answer

The formula =MATCH("return",A1:E1,0) is the best choice because it searches for the exact match of the word "return" in the range A1:E1. The "0" at the end of the formula ensures that the exact match is required. Option B is incorrect because "return" needs to be in quotes. Option C is incorrect because the parameters in the formula are in the wrong order. Option D is incorrect because "0:1000" is not a specific range and will not look for "return" in the correct cells.

Violet Is Learning How to Use the MATCH Function and Is