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.

Question

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.

Quizplus · Accepted Answer

The auditing information shows that the SUMPRODUCT function is being used to calculate wages, multiplying the hours worked by the hourly wage. However, the hours being used in the calculation are from the previous pay period, not the current pay period, indicating that the model is using the wrong hourly wage information. Therefore, statement C is true.

A Spreadsheet Modeler Is Creating a Spreadsheet to Calculate Each