The Process of Changing Cells in a Worksheet to See

question 11

Multiple Choice

The process of changing cells in a worksheet to see how those changes affect the outcome of formulas is known as ________.

• A)Goal Seek
• B)what-if analysis
• C)General fund analysis
• D)Relative cell reference

---

Definitions:

Standard Deviation

A measure of the amount of variation or dispersion in a set of values, often used to quantify the volatility of a financial instrument or investment portfolio.

Stock-index Mutual Fund

A mutual fund that mimics the composition and performance of a particular stock market index, allowing investors to invest in the performance of the whole market or specific sectors.

S&P 500

A benchmark tracking the performance of 500 major U.S. companies listed on stock exchanges.

Diversification Benefit

The reduction of risk achieved by allocating investments among various financial instruments, industries, or other categories to maximize return.