A Spreadsheet Modeler Is Creating a Spreadsheet to Calculate Each

question 40

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:

Appliances

Electrical or mechanical machines designed for a specific function, commonly found in homes or businesses, such as refrigerators, washing machines, or ovens.

Upper-upper Class

The segment of society that holds the highest level of wealth, influence, and prestige.

Patrician

Relates to a member of the nobility or aristocracy, often used historically to describe high-status individuals in Roman society.

Power Elite

A term referring to a small group of people in a society who hold a disproportionate amount of wealth, privilege, political power, or skill.