際際滷

際際滷Share a Scribd company logo

(Test solution)excel 2013 chapter 2 lab test b solution

D
deborah canning

This payroll summary shows employee names, dependents, hourly rates, hours worked, gross pay, taxes, and net pay for nine employees of Timothy's Technology Repair. Totals are provided for all employees as well as averages for dependents, hourly rate, hours worked, and pay. The employee with the highest pay is listed along with the employee with the lowest pay.

1 of 1
Download to read offline
Steven Freund Lab Test B CIS 101 Employee Dependents Hourly Rate Hours Worked Gross Pay Taxes Net Pay Johnny Goldstein 1 $10.40 40.00 $416.00 $78.33 $337.67 Mark Milford 2 11.20 40.00 448.00 79.86 368.14 Robert Armstrong 2 15.90 21.25 337.88 57.83 280.04 Jennifer Brickman 3 11.30 23.50 265.55 38.49 227.06 Mary Cortright 1 16.10 37.50 603.75 115.88 487.87 Peter Silviano 2 10.75 40.00 430.00 76.26 353.74 Michelle Sanchez 1 12.60 25.00 315.00 58.13 256.87 Melissa Tu 3 12.20 37.50 457.50 76.88 380.62 Belinda Donahue 1 16.00 30.00 480.00 91.13 388.87 Totals 294.75 $3,753.68 $672.78 $3,080.89 Highest 3 $16.10 40.00 $603.75 $115.88 $487.87 Average 2 $12.94 32.75 $417.08 $74.75 $342.32 Lowest 1 $10.40 21.25 $265.55 $38.49 $227.06 Timothy's Technology Repair Payroll Summary

More Related Content

(Test solution)excel 2013 chapter 2 lab test b solution

  • 1. Steven Freund Lab Test B CIS 101 Employee Dependents Hourly Rate Hours Worked Gross Pay Taxes Net Pay Johnny Goldstein 1 $10.40 40.00 $416.00 $78.33 $337.67 Mark Milford 2 11.20 40.00 448.00 79.86 368.14 Robert Armstrong 2 15.90 21.25 337.88 57.83 280.04 Jennifer Brickman 3 11.30 23.50 265.55 38.49 227.06 Mary Cortright 1 16.10 37.50 603.75 115.88 487.87 Peter Silviano 2 10.75 40.00 430.00 76.26 353.74 Michelle Sanchez 1 12.60 25.00 315.00 58.13 256.87 Melissa Tu 3 12.20 37.50 457.50 76.88 380.62 Belinda Donahue 1 16.00 30.00 480.00 91.13 388.87 Totals 294.75 $3,753.68 $672.78 $3,080.89 Highest 3 $16.10 40.00 $603.75 $115.88 $487.87 Average 2 $12.94 32.75 $417.08 $74.75 $342.32 Lowest 1 $10.40 21.25 $265.55 $38.49 $227.06 Timothy's Technology Repair Payroll Summary