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
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, so pressed Ctrl~ to show formulas. Which of the following statements is true?
A B C
Wage per hour
Employee Hours Total Wages
$B$B
$B$B
$B$B
$B$B
$B$B
Multiple Choice
The model is incorrect only because it is using the wrong information for the employee hours.
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.
The model is incorrect only because it is using the wrong wage information.
The model is incorrect, but it is impossible to determine why.
There is no error in the model.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
