A spreadsheet modeler is creating a spreadsheet to calculate each employee's total wages for a time period After entering the data below. the modeler would like to enter a formula in cell C5 that can then be copied to cells C6 through C9 without further modification. What formula should be entered in cell C5 to make this possible? B C 1 2 Wage $11.50 per hour 3 4 Employee Hours Total Wages 5 1 40 6 2 35 7 3 28 B 4 17 9 5 25 10 Multiple Choice =B2B5 =B2 $B$5 SBS2 B5 =$B$2"$B$5 B2-85 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 B 11.5 per hour A 1 2 Wage 3 4 Employee 51 6 2 7 3 84 95 10 Hours 40 35 28 17 25 Total Wages -$B$2A5 $0$2" A6 -$B$2A7 $B$2*AB -$8$2*A9 Multiple Choice There is no error in the model The model is incorrect because it is using the wrong information for the employee hours. The model is incorrect because it is using the wrong wage information The model is incorrect, but it is impossible to determine why 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