Excel's _____ Function Can Be Used to Compute the Data

question 10

Multiple Choice

Excel's _____ function can be used to compute the data value occurring most frequently.

• A) MAX
• B) AVERAGE
• C) MEDIAN
• D) MODE.SNGL

---

Definitions:

Compounded Monthly

Interest calculation method where the interest is calculated and added to the principal balance each month, allowing for the interest to then earn interest in subsequent months.

Monthly Payment

A specific amount of money that is paid every month, commonly associated with loans or leases.

Effective Rate of Return

The actual annual interest earned or paid on an investment or loan, considering the effect of compounding.

RRSP

Registered Retirement Savings Plan, a Canadian financial retirement savings tool for individuals to hold investment assets and savings tax-deferred until withdrawal.