A Spreadsheet Modeler Is Creating a Spreadsheet to Calculate Each

question 23

Multiple Choice

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.

• A) There is no error in the model.
• B) The model is incorrect because it is using the wrong information for the employee hours.
• C) The model is incorrect because it is using the wrong wage information.
• D) The model is incorrect, but it is impossible to determine why.
• E) The model is incorrect because it is using the wrong information for the employee hours and the model is incorrect because it is using the wrong wage information are both true.

---

Definitions:

Color Tv

A television set that can display images in color, as opposed to black and white.

Hot Tub

A large tub filled with hot water and used for relaxation or hydrotherapy, often equipped with jets for massage.

Tinker Creek

A stream in Virginia, notably written about by Annie Dillard in her work "Pilgrim at Tinker Creek," exploring nature and life.

Shade Trees

Large trees planted specifically to provide shade and reduce heat in surrounding areas, often enhancing comfort and energy efficiency.