KEMBAR78
Ms Excel 2023 | PDF | Spreadsheet
Scribd
Upload
13 views1 page

Ms Excel 2023

The document outlines a task for creating a payroll spreadsheet using MS Excel, including specific data entry and formatting instructions. It details the calculations needed for gross pay, social security tax, and net pay for employees, along with formatting requirements for the spreadsheet. Additionally, it provides contact information for ATIAM College.

Uploaded by

justinachier4
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
13 views1 page

Ms Excel 2023

The document outlines a task for creating a payroll spreadsheet using MS Excel, including specific data entry and formatting instructions. It details the calculations needed for gross pay, social security tax, and net pay for employees, along with formatting requirements for the spreadsheet. Additionally, it provides contact information for ATIAM College.

Uploaded by

justinachier4
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

College

Where professionals are made

MS Excel
Task 1
Open a spreadsheet program and key in the following data. Save it as payroll in the FINALEXAMS
folder to print out later.

A B C D E F G
1 PAYROLL
2 Date 20/08/2023
3 EMPL Number NAMES Hourly Hours Gross S.S Tax Net Pay
Rate Worked Pay
4 E000001 Ford 7.5 35 ? ? ?
5 E000002 Mino 8 30 ? ? ?
6 ? Bell 6.5 25 ? ? ?
7 ? Davis 9 40 ? ? ?
8 ? Turro 10 39 ? ? ?

1. Enter the labels and values in the exact cells locations as desired
2. Use autofill to put the employee numbers into cells A6:A8
3. Set the columns width and rows appropriately
4. Use warp text and merge cells as desired
5. Apply borders, gridlines and shading to the table as desired
6. Format cell B2 to short date format
7. Format cells E4:G8 to include dollar sign with two decimal places
8. Calculate the gross pay for employee; enter a formula in cell E4to multiply hourly rate by hours
worked
9. Calculate the social security tax (S.S tax), which is 6% of the gross pay; enter a formula in cell F4
to multiply Gross pay by 6%
10. Calculate the Net Pay; enter a formula in cell G4 to subtract social security tax from gross pay
11. Set the work sheet vertically and horizontally on the page
12. Save your work

Location: Komarock Sector 3A, near Infill B round about.


Telephone : 0793746046
Email: admin@atiamcollege.co.ke
P.O Box: 634-00518, Nairobi, Kenya. ATIAM College atiam_college @Atiam_College

You might also like