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 now wants to send any orders for more than 30 toys to Warehouse 2. She is looking for the position where the smallest value is greater than 30. She will send the orders starting from that position on to Warehouse 2. The correct formula would be ____.
A) =MATCH(31,A1:E1,-1)
B) =MATCH(31,A1:E1,0)
C) =MATCH(31>=A1:E1,-1)
D) =MATCH(31<=A1:E1,0)
Correct Answer:
Verified
Q97: The CHOOSE function can return a value
Q98: The function named IFERROR combines aspects of
Q99: When using an INDEX function, you can
Q100: The INDEX function can solve for _.
A)
