A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period. The modeler has named cell B2 "Hourly_Wage" to make the model more understandable. What formula should be entered into cell C5?
A) =B1*B5
B) =B1*$B$5
C) =Hourly_Wage*B5
D) =$B$2*Hourly_Wage
E) =Hourly_Wage +B5

Question

A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period. The modeler has named cell B2 "Hourly_Wage" to make the model more understandable. What formula should be entered into cell C5? 
A) =B1*B5 
B) =B1*$B$5 
C) =Hourly_Wage*B5 
D) =$B$2*Hourly_Wage 
E) =Hourly_Wage +B5

Quizplus · Accepted Answer

The modeler named cell B2 "Hourly_Wage" for clarity, so it makes sense to use that name instead of the cell reference in the formula. Therefore, the correct formula to calculate an employee's total wages would be the hourly wage multiplied by the number of hours worked, which is represented by the value in cell B5. This can be expressed as "=Hourly_Wage*B5" in cell C5.

A Spreadsheet Modeler Is Creating a Spreadsheet to Calculate Each