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.
-Violet is not sure if the Sales department is filling in the word "return" in uppercase or lowercase letters. What is the correct way to write "return" in a MATCH formula?
A) return
B) RETURN
C) Return
D) It doesn't matter; the MATCH formula does not distinguish between upper- and lowercase letters.

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.
-Violet is not sure if the Sales department is filling in the word "return" in uppercase or lowercase letters. What is the correct way to write "return" in a MATCH formula?
A) return 
B) RETURN 
C) Return 
D) It doesn't matter; the MATCH formula does not distinguish between upper- and lowercase letters.

Quizplus · Accepted Answer

The MATCH function is not case sensitive, so it does not matter if "return" is written in uppercase or lowercase letters.

Violet Is Learning How to Use the MATCH Function and Is