Violet Is Learning How to Use the MATCH Function and Is

question 57

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 wants to send any orders for 30 toys or fewer to Warehouse 1 to ship out. To do this, she locates the position in the chart where the greatest value does not exceed 30. The formula is ____.

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

---

Definitions:

Direct Labor-Hours

A measure of the time directly spent by workers on producing a product or delivering a service, often used to allocate manufacturing overhead.

Overhead Applied

The allocation of overhead costs to produced goods based on a pre-determined rate or basis such as direct labor hours or machine hours.

Assembly Department

A part of a production facility where pieces are combined to form complete products.

Direct Labor-Hours

Direct labor-hours measure the amount of time workers or employees spend directly working on producing goods or providing services.