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

Verified
Correct Answer:
Verified
Q28: When solving an HLOOKUP formula, Excel looks
Q29: The first row (key values) of the
Q30: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Violet is
Q31: You can only use a LOOKUP function
Q32: The ISBLANK function checks whether a specified
Q34: To find and retrieve data from a
Q35: A vertical lookup table is a lookup
Q36: In an INDEX function, the argument _
Q37: When using the CHOOSE function, if the
Q38: The INDEX function allows you to retrieve