computer comp.

Excel Assignment

 Title in Cell A1 – Bookstore Payroll

Create table in excel

Table: 8 columns and 10 rows

Column headings:

 Column 1: Cell A3 - Employees First Name

 Column 2: Cell B3 - Employee Last Name

 Column 3: Cell C3 - Monthly Gross

 Column 4: Cell D3 - Soc. Security

 Column 5: Cell D3 - Medicare

 Column 6: Cell E3 - Federal Tax

 Column 7: Cell F3- State Tax

 Column8: Cell G3 - Net Pay

Add the First Names to Column 1, Last Name to column 2 and Level to Column 3

 John Doe Entry Level

 Melissa Page Junior Level

 Robert Moses Senior Level

 Jones Beach Junior Level

 Paul Simon Senior Level

 Sue Ellen Entry Level

 Mike Pro Junior Level

 Pete Lee Senior Level

 Maya Lou Junior Level

 Mary Pie Junior Level

 Bottom row Totals

 Each Employee works a total of 40 hours a week.

Use an excel formula to calculate each of these:

 Monthly Gross Income

 Social Security Employee

 Social Security Employer

 Federal tax

 State tax

 Net pay for each

 Totals

 Sort employee last in ascending order

Save file and upload to Dropbox.