Case 19-1 Macy Is the Treasurer for a Professional Organization

question 37

Multiple Choice

Case 19-1 Macy is the treasurer for a professional organization, and she is compiling the financial data to present to the board members at the next meeting. Macy wants to show the organization's total dollar amount of dues collected in the cells B2 to B40. Which is the correct formula?

• A) =COUNT(B2:B40)
• B) =SUM(B2,B40)
• C) =SUM(B2:B40)
• D) =TOTAL(B2:B40)

---

Definitions:

Closing Rate

The exchange rate used to convert foreign currency transactions and balances into the reporting currency of a company at the end of an accounting period.

Historical Rate

The exchange rate at which a foreign currency transaction was converted into the reporting currency at the time of the transaction.

Fluctuation

Variations or changes in value or level, often used in the context of financial markets or economic indicators.

Interest Rates

The cost of borrowing money or the return on savings, typically expressed as a percentage.