Case EX 13-2 Gregory Works for the Local Public Television

question 570

Multiple Choice

Case EX 13-2 Gregory works for the local public television station. The station has recently held a TV pledge drive and they have received a large number of pledges from viewers and businesses. The data about the pledge drive is stored in a worksheet. The worksheet has six columns: First Name, Last Name, Address, Phone, Pledge, Received. The Received column contains "Yes" or "No" values depending on whether the amount pledged has been received by the station. From only the pledges which have been received, Gregory wants to find out the average amount pledged. He can first filter the data and then use the ____ function.

• A) SUMIF
• B) COUNTA
• C) COUNT
• D) Subtotal

---

Definitions:

Financial Markets

Platforms where individuals and entities can trade financial securities, commodities, and other fungible items of value at low transaction costs.

Extraordinary Returns

Profits that significantly exceed the norm or benchmark, often due to unusual or rare events affecting the investment.

Net Present Values

The calculation that compares the value of all cash inflows and outflows of a project or investment using a discount rate to determine if it will yield a positive return.

Historical Record

Documentation or archives of past events, transactions, or values, often used for reference.