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 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)
Correct Answer:

Verified
Correct Answer:
Verified
Q25: The LOOKUP function uses a _ lookup
Q26: A data list that categorizes values you
Q27: The syntax of the CHOOSE function is
Q28: When solving an HLOOKUP formula, Excel looks
Q29: The first row (key values) of the
Q31: You can only use a LOOKUP function
Q32: The ISBLANK function checks whether a specified
Q33: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Violet is
Q34: To find and retrieve data from a
Q35: A vertical lookup table is a lookup