When You Paste Formula Cells Using the Paste Button in the Clipboard

question 468

Multiple Choice

When you paste formula cells using the Paste button in the Clipboard group, which of the following is true?

• A) A button appears near the selected cells with options for pasting formulas and values.
• B) The formula is copied with cell references you must adjust to avoid worksheet errors.
• C) The Auto Fill Options button appears.
• D) Pointing to the destination cell displays a preview of the cell contents.

---

Definitions:

Risk-Free Asset

An investment that is considered to have negligible risk of financial loss, typically government bonds of stable countries.

Capital Allocation Line

A line representing the risk-return trade-off of different portfolios, showing the highest expected return for a given level of risk.

Standard Deviation

A measure of the dispersion or variation in a set of values, indicating how much the values differ from the mean of the set.

Complete Portfolio

A portfolio that includes both risky assets and a risk-free asset, optimizing the balance between risk and return.