When Using Excel for Simulation, It Is Important to Freeze

question 14

Multiple Choice

When using Excel for simulation, it is important to freeze the random numbers used in order to compare the effectiveness of different policies. To do this, you must select the cells holding the random numbers with the mouse, click Edit/Copy at the top of the spreadsheet, and:

• A) click Edit/Paste Special and select the Values option.
• B) click Edit/Paste to freeze the cells.
• C) click Edit/Paste Special and select the Formulas option.
• D) move to a different section of the spreadsheet, then click Edit/Paste to freeze the cells.

Compute total returns considering both income and appreciation aspects of an investment.

Interpret and apply compound interest calculations to predict future investment values and returns based on historical data.

Understand the concepts of income yield, capital gain yield, and total return in bond investments.

Calculate the income yield on bond investments.

---

Definitions:

United Nations Convention

An international treaty or agreement formulated under the auspices of the United Nations, pertaining to various global issues.

International Sales Contract

A legally binding agreement between parties from different countries for the sale and purchase of goods.

Market Price

The present cost at which a service or asset is available for purchase or sale on the market.

Notice of Breach

A formal notification given to a party indicating that they have failed to fulfill their contractual obligations.