The ____ Function Is Useful When You Want to Add

question 14

Multiple Choice

The ____ function is useful when you want to add values in a range only if they meet criteria.

• A) COUNTIF
• B) MATCH
• C) INDEX
• D) SUMIF

---

Definitions:

Investment Portfolio

Set of securities chosen by an investor.

Sure Profit

A guaranteed financial gain with no risk of loss, often considered unrealistic in most trading or investment scenarios.

Factor Loadings

Quantitative measures of how much a factor affects a given variable, often used in factor analysis to assess investment performance.

Multifactor APT

Multifactor APT, or Arbitrage Pricing Theory, is a model that describes the expected return on a financial asset as a linear function of various macroeconomic factors or theoretical market indexes.