Solved

Violet Is Learning How to Use the MATCH Function and Is

Question 39

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

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q34: To find and retrieve data from a

Q35: A vertical lookup table is a lookup

Q36: In an INDEX function, the argument _

Q37: When using the CHOOSE function, if the

Q38: The INDEX function allows you to retrieve

Q40: A lookup table can have only one

Q41: The syntax of the VLOOKUP function is

Q42: The V in VLOOKUP stands for velocity.

Q43: In a VLOOKUP function, the argument _

Q44: The function =_(index_num,value1,value2,…) can return up to