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 wants to send any orders for 30 toys or fewer to Warehouse 1 to ship out. To do this, she locates the position in the chart where the greatest value does not exceed 30. The formula is ____.
A) =MATCH(30,A1:E1,0)
B) =MATCH(30,A1:E1,1)
C) =MATCH(30>,A1:E1,1)
D) =MATCH(30<A1:E1,0)
Correct Answer:

Verified
Correct Answer:
Verified
Q52: If the values you want to look
Q53: In an INDEX function, the argument _
Q54: You can only use a LOOKUP function
Q55: The syntax of the CHOOSE function is
Q56: You cannot use VLOOKUP, HLOOKUP, or LOOKUP
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
Q62: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Violet is