Using Formulas in Excel

  • Due No Due Date
  • Points 20
  • Submitting a file upload

Open your Irish Nursery Workbook.  

On the Payroll worksheet use formulas to:

  1. Calculate each employee's total hours.
  2. Calculate each employee's gross pay and the total of all employee's gross pay.
  3. Calculate each employee's deductions. (Normally deductions are complicated, for this class, we will assume that each employee has 27% of their gross pay deducted for taxes.)   Calculate the total amount of deductions.
  4. Calculate each employee's net pay and the total net pay for the company.

 

Please note: I will be grading on your use of formulas, so don't just do your own calculations and type in the answers.

Save the changes to your thumb drive and upload to canvas.

0