Into the Woods Camping Gear is a company that retails camping goods for the occasional camper, both at a brick-and-mortar store and online. You have been asked update the weekly payroll report to reflect changes in personnel, to update certain mandatory deductions, and to add overtime computations. The final worksheet is shown in Figure 3 - 86.

To complete this assignment, you will be required to use the Data Files for Students. Visit www.cengage.com/ct/studentdownload for detail instructions or contact your instructor for information about accessing the required files.

Instructions

Run Excel. Open the workbook, Lab 3-2 Into the Woods Weekly Payroll Report and then save workbook using the tile name, Lab 3-2 Into the Woods Weekly Payroll Report Complete.

1. Apply the Wisp theme to the worksheet and then bold the entire worksheet.

2. Delete rows 12 through 14 to remove the statistics below the Totals row.

3. Delete column B. Set Column A width to 32.00, and columns B through K to 11.00. Select row 3 and set text to wrap in this row using the Wrap Text button (HOME tab 1 Alignment group), and then set the row height to best fit.

4. Delete the record for the employee Cloutier, James. Add two blank lines immediately above the Total row, and add the information for the two new employees listed in Table 3 - 11.

Table 3 - 11 into the Woods Camping Gear New Employee Data

Employee _______ Withholding Allowances _____ Rate Per Hour ____ Hours Worked

Alvarez, Luis .................... 1 ............................ 14.00 .................. 35

Grey, Samantha.................. 2 ............................ 14.00 .................. 52