Practice with Formulas - Payroll Spreadsheet

You will be creating a spreadsheet of "fictitious" payroll information for 10 employees. These employees can be your friends, family, relatives, etc.

Requirements:

1. Spreadsheet must include 10 employees (use family members, friends, etc. as your employees)
2. Go to Edit > Headers and Footers. Create a center header that says _________'s Payroll Spreadsheet. The left header should have the date, and the right header should have your Block. Also, go to Format > Page, click the sheet tab, and change the page orientation to landscape.
3. Click in cell A1 and type Payroll Spreadsheet. Make the font size 14 and bold. Click and drag over to cell G1 and merge the cells. Center the title.
4. Your column headings should be as follows: Employee Number (A3), Employee Name (B3), Hourly Rate (you make this up in dollars in cell C3), Hours worked (each person should be different and their hours should range from 10-40 and should be typed in cell D3), Gross Pay (E3), Federal Tax (F3), Social Security Tax (G3), NJ Tax (H3), Total Deductions (I3), and Net Pay (J3).
5. Type the following formulas into each of these cell references: Use the CELL REFERENCES in place of the words in parentheses. Remember to use the fill handle to copy your formulas.

E4 type: =Sum(hours worked*hourly rate); F4 type: =Sum(gross pay*.15); G4 type: =Sum(gross pay*.07); H4 type: =Sum(gross pay*.07); I4 type: =Sum(Fed tax:NJ state tax); J4 type: =Sum(Gross pay - total deductions).

**Save as Payroll Spreadsheet when finished. DO NOT PRINT.