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:

Acquisition

The act of acquiring control of another company or business unit by purchasing its shares or assets.

Consolidated Additional Paid-in Capital

The excess amount investors pay over the par value of shares, aggregated from all subsidiaries of a parent company and reported on the consolidated financial statements.

Additional Paid-in Capital

The amount of money investors have paid for shares above their nominal value during the issuance of stock.

Voting Shares

Shares of a company that grant the shareholder the right to vote on company matters, such as electing the board of directors.