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:

Seasonal Sales

Sales fluctuations that occur at certain times of the year, often due to changes in weather, holidays, or other seasonal factors.

Cash Disbursements

The outflow of cash to pay expenses, purchase assets, or repay debts.

Floor Plan

In finance, it refers to a type of short-term loan used by retailers to purchase high-cost inventory such as automobiles. In architecture, it's the scale diagram of the arrangement of rooms in a building.