A Spreadsheet Modeler Is Creating a Spreadsheet to Calculate Each

question 49

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 formula 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:

Minor Failure

A small or insignificant defect or flaw, especially in a product, system, or mechanism, that does not generally inhibit its intended function.

Repudiation

The rejection or refusal to acknowledge or pay a debt or fulfill a contractual obligation, often leading to a breach of contract claim.

Frustration

A legal doctrine that excuses parties from fulfilling their contract obligations due to unforeseen circumstances rendering the contract impossible, illegal, or radically different.

Frustrating Event

An unforeseen event that significantly changes the conditions of a contract, making it impossible to fulfill and potentially voiding the agreement.