Objectives:
Introduction to MS Excel files, Workbooks, Worksheets, Columns and Rows.
Formatting Worksheets.
AutoFill, Numeric formats, previewing worksheets.
- Create a new workbook as shown below and save the file with the name “Payroll”.
- Enter the labels and values in the exact cells locations as desired.
- Use AutoFill to put the Employee Numbers into cells A6:A8.
- Set the columns width and rows height appropriately.
- Set labels alignment appropriately.
- Use warp text and merge cells as desired.
- Apply borders, gridlines and shading to the table as desired.
- Format cell B2 to Short Date format.
- Format cells E4:G8to include Rs sign with two decimal places.
- Calculate the Gross Pay for employee; enter a formula in cell E4 to multiply Hourly Rate by Hours Worked.
- 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%.
- Calculate the Net Pay; enter a formula in cell G4 to subtract Social Security Tax from Gross Pay.
- Format cell B2 to Short Date format.
