When Testing a Spreadsheet Model by Entering Values in the Changing

question 47

Multiple Choice

When testing a spreadsheet model by entering values in the changing cells, which of the following are appropriate values to enter?

• A) Zeroes.
• B) Values for which you know what the values of the output cells should be.
• C) Large numbers.
• D) Zeros, large numbers, and inputs for which you know what the values of the output cells should be.
• E) All of the answer choices are correct.

---

Definitions:

Compounded Annually

The process of adding interest to the principal sum of a deposit or loan, with the interest that has been added also earning interest from that point on.

Invest

Dedicating financial resources with the objective of achieving income or profit returns.

Fund

A pool of money set aside for a specific purpose or allocated for investing in various assets.

Interest

The cost of borrowing money or the return on investment, usually expressed as a percentage of the principal.