Solved

Violet Is Learning How to Use the MATCH Function and Is

Question 62

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

Correct Answer:

verifed

Verified

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

Related Questions