Exam 4: The Art of Modeling With Spreadsheets

A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period. After completing the model, the analyst feels there is an error. Interpret the auditing information shown below to determine which of the following statements is TRUE.

Which of the following statements about a "poor" spreadsheet model is FALSE?

A spreadsheet developer enters the formula "=$B$9*$B$10" into cell C1. If this formula is copied and then pasted into cell C2, what will the formula in cell C2 be?

A spreadsheet developer enters the formula "=B9*B10" into cell C1. If this formula is copied and then pasted into cell C2, what will the formula in cell C2 be?

The auditing tools can be used to trace the cells that make reference to a particular cell.

Which of the following is not a part of the planning step when building a spreadsheet model?

Whenever possible, the entire model should be displayed on the spreadsheet.

Which of the following can be done using the auditing tools in Excel?

A relative reference changes when it is filled or copied into other cells.

When a number is needed in an output cell, it should typically be entered there directly.

Which of the following statements about a good spreadsheet model is FALSE?

Which of the following is not a major step in the process of modeling with spreadsheets?

An absolute reference does not change when it is filled or copied into other cells.

Which of the following best describes spaghetti code?

If two managers are given the same business problem to analyze with a spreadsheet, their spreadsheet models will likely be almost identical.