Violet Is Learning How to Use the MATCH Function and Is

question 51

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.
-Violet now wants to send any orders for more than 30 toys to Warehouse 2. She is looking for the position where the smallest value is greater than 30. She will send the orders starting from that position on to Warehouse 2. The correct formula would be ____.

• A) =MATCH(31,A1:E1,-1)
• B) =MATCH(31,A1:E1,0)
• C) =MATCH(31>=A1:E1,-1)
• D) =MATCH(31<=A1:E1,0)

---

Definitions:

Economies of Scale

The cost advantages that enterprises obtain due to their scale of operation, resulting in a decreased cost per unit.

Positive Economic Profits

Earnings that exceed the total opportunity costs of all inputs, indicating a return above the normal profit level.

Expand

To increase in size, number, or importance, often relating to businesses aiming to grow through increased operations, product lines, or market reach.

Equilibrium

The condition that exists when quantity supplied and quantity demanded are equal. At equilibrium, there is no tendency for price to change.