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 Customer Service department tells Violet there is a 25% discount on orders of 500 toys or more. Violet knows there is only one order that large, for 1000 toys, so which of the following formulas does she write to find the position of this order?
A) =MATCH(1000,25%,A1:E1,1)
B) =MATCH(1000,A1:E1,0)
C) =MATCH(1000,{1000,100,50,25,0},0)
D) =MATCH(A1:E1,0,1000)

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 Customer Service department tells Violet there is a 25% discount on orders of 500 toys or more. Violet knows there is only one order that large, for 1000 toys, so which of the following formulas does she write to find the position of this order?
A) =MATCH(1000,25%,A1:E1,1) 
B) =MATCH(1000,A1:E1,0) 
C) =MATCH(1000,{1000,100,50,25,0},0) 
D) =MATCH(A1:E1,0,1000)

Quizplus · Accepted Answer

The correct formula to find the position of the order for 1000 toys in a range A1:E1 is =MATCH(1000,A1:E1,0). This formula uses the MATCH function to search for the exact value of 1000 within the specified range and returns its position. The third argument, 0, specifies that it should look for an exact match.

Violet Is Learning How to Use the MATCH Function and Is