Describe how you incorporated each of the design principles into your spreadsheet model
What will be an ideal response?
• Accuracy: Every value entered is correct and every formula has been checked for correctness.
• Clarity: Monetary values are formatted as Currency, APR and estimated growth rates are formatted as percent, and units are provided when applicable.
• Flexibility: Cell references or named ranges are used in formulas.
• Efficiency: Appropriate Excel functions are used to calculate the total cost of the loan and other calculations.
• Documentation: Appropriate labels are used for each value along with a title at the top of the model as well as comments to identify the inputs, decision/uncertain variables, and outputs.
You might also like to view...
In the context of a contract, the acquiring organization is typically referred to as what term?
A. Buyer B. Acquirer C. Owner D. Client
To move from the second cell in the table in the accompanying figure back to the previous cell, press the ____ key(s).
A. TAB B. DELETE C. SHIFT-TAB D. SHIFT-RETURN