Please help me out with step by step instructions on an excel file along with the screenshots as to how to get it done. Thank You. There should be 6 excel worksheets.

Design and create a workbook to keep track of the payroll for hourly employees. Each worksheet will correspond to a different week. You have six employees. List them in a column. Each employee makes a different amount per hour. List the hourly pay for each employee in a new column. Now add a column for each of the seven days of the week. In these columns enter the number of hours worked by each employee each day that week. To the right add columns that give the total number of hours worked by each employee and the gross pay for each employee. The federal government asks you to deduct 20% of gross pay for federal income taxes. Your state or province asks you to deduct 5% of income taxes. Add columns for these. Social Security deduction is 62% of gross pay. The deduction for medical insurance is $30 per week. Add columns for these. Each employee's take home pay is the gross pay minus the deductions. Add a column for take home pay. Add a row to total all of the columns. Add appropriate cells with headings for the worksheet. gross pay for state Now use the worksheet you just created for one week's payroll to create a workbook for a month (four weeks) You should have an initial worksh information. There should be one workshect for each week. Employees may work different hours from week to week. The final worksheet should be the totals for the four weeks. There should be six worksheets in all. eet that gives a title and on