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

Question

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)

Quizplus · Accepted Answer

The correct formula is =MATCH(30,A1:E1,1) because it searches for the largest value that is less than or equal to 30 in a range that is assumed to be in ascending order. The third argument "1" specifies this type of search.

Violet Is Learning How to Use the MATCH Function and Is