A Spreadsheet Modeler Is Creating a Spreadsheet to Calculate Each

Multiple Choice

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