Violet Is Learning How to Use the MATCH Function and Is

question 30

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)

---

Definitions:

Market Entry

The process by which a new competitor enters an existing market, often involving overcoming barriers to entry.

AVC

Average Variable Cost, which is the total variable costs of production divided by the quantity of output produced.

Economic Profits

Profits calculated by subtracting both explicit and implicit costs from revenue; also known as supernormal profits.