Which Excel Function Averages Cells in a Range Based on a Specified

question 13

Multiple Choice

Which Excel function averages cells in a range based on a specified condition?

• A) AVERAGEIF
• B) AVERAGE
• C) COUNTIF
• D) SUMIF

---

Definitions:

Weighted Average Cost of Capital (WACC)

The rate that a company is expected to pay on average to all its security holders to finance its assets, a significant part of corporate finance.

Debt-Equity Ratio

A ratio calculating the balance of debt and equity utilized for financing a company's assets.

Risk-Free Rate

A hypothetical profit rate from a risk-free investment, usually shown by the earnings on state-backed securities.