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 shipping manager asks Violet to send any orders for 100 toys over immediately because they are testing a new box that will hold exactly 100 toys. In order to determine the position in the chart for the order with 100 toys, she writes the formula ____.
A) =MATCH(4,A1:E1,0)
B) =MATCH(100,A1:E1,0)
C) =MATCH(100,A1:E1,-1)
D) =MATCH(100{A1,E1},-1)

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.
-The shipping manager asks Violet to send any orders for 100 toys over immediately because they are testing a new box that will hold exactly 100 toys. In order to determine the position in the chart for the order with 100 toys, she writes the formula ____.
A) =MATCH(4,A1:E1,0) 
B) =MATCH(100,A1:E1,0) 
C) =MATCH(100,A1:E1,-1) 
D) =MATCH(100{A1,E1},-1)

Quizplus · Accepted Answer

To determine the position in the chart for the order with 100 toys, Violet should use the formula =MATCH(100,A1:E1,0) since it will search for the value "100" in the range A1:E1 and return the position of the first exact match (or an error if there is no match).

Violet Is Learning How to Use the MATCH Function and Is