Gross Pay is regular hours times wage plus overtime hours times wage times 1.5. Life insurance, workers compensation, and federal tax rates are given below the headings. These are percentages of gross pay. You should be able to just write the formula for life insurance in the first row, and copy it to the rest of the rows and the two columns for workers comp and federal tax, by using mixed cell references.
Net pay is gross pay minus the deductions.
The totals should only be calculated for those columns for which it makes sense. Please hand in a printout of the sheet on a single page with your name as the heading. Also hand in a printout of formulas of the sheet.