Microsoft Office Tutorials and References
In Depth Information
To complete this task:
1. Create a new workbook named Payroll1 , and save it in the Tutorial.03\Cases folder
included with your Data Files.
2. Name two worksheets “Documentation” and “Payroll,” and then delete the third sheet.
3. On the Documentation sheet, include the name of the company, your name as the
author of the workbook, the date the workbook is being created, and a brief descrip-
tion of the purpose of the workbook.
4. On the Payroll worksheet, enter the payroll table shown in Figure 3-43.
5. Enter the formulas to calculate total hours, gross pay, federal withholding tax, state
withholding tax, total deductions, and net pay, using the following information:
a. Gross pay is equal to the number of hours multiplied by the pay rate.
b. Federal withholding tax is equal to 15% of the gross pay.
c. State withholding tax is equal to 4% of the gross pay.
d. Total deductions are the sum of federal and state withholdings.
e. Net pay is equal to the difference between the gross pay and the total amount of
6. Format the appearance of the payroll table using the techniques you learned in this
tutorial. The appearance of the payroll table is up to you; however, do not use an
AutoFormat design to format the table.
7. Format the printed page, setting the print area and inserting an appropriate header
and footer. Only a few employees are entered into the table at present. However,
after Jim Oritz approves your layout, many additional employees will be added,
which will cause the report to cover multiple pages. Format your printout so that the
worksheet title and column titles appear on every page.
8. Preview your worksheet, and then print it. Save your changes.
9. Add the following new employees to the worksheet. The employee list should be in
alphabetical order, so these new employees should be inserted at the appropriate
places in the sheet:
Name Hours Pay Rate
Carls 20 10.50
Lopez 35 11.50
Nelson 20 9.50
10. Preview the revised worksheet, and then print it.
11. Save this revised workbook as Payroll2 in the Tutorial.03\Cases folder, and then close the