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.
Correct Answer:

Verified
Correct Answer:
Verified
Q57: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Violet is
Q58: Write the correct syntax for the LOOKUP
Q59: In a VLOOKUP function, the argument _
Q60: In the VLOOKUP function, if a type
Q61: In a FALSE VLOOKUP, if an exact
Q63: With the INDEX function, if you are
Q64: The syntax of the HLOOKUP function is
Q65: The _ function returns the relative position
Q66: The ISBLANK function tests for a(n) _.<br>A)
Q67: MATCHING<br>Identify the letter of the choice that