Part I: 

Create two sub-directories, PATOKA and HARDY on your diskette.

After finishing the spreadsheet given in Part II, save the file under the name "CLA2-2" on the PATOKA folder.

Copy the file from the PATOKA folder to the SHEETS sub-directory on the your network account root

Make a copy of the folder PATOKA and save it under HARDY.

Remove the PATOKA folder from the root of your diskette.

You are employed by the payroll department of a construcion firm.You have been asked to prepare a biweekly payroll report for the following six employees: (Page QP128 of your textbook)

Enter the data and formulas as shown on page QP129 of your textbook.

Enhance the spreadsheet, as requested.

Print and submit the cells formula version and the "As displayed version" of the spreadsheet.

Your supervisor in the payroll departenmt has asked you to modify the payroll notebook developed above. The major modificaions include refomatting the spreadsheet, computing overtime as time-and-one-half for hours worked exceeding 80, deducting no federal tax if the federal tax is greater than the gross pay, and computing of the social security deduction, and adding two new employees. Go to page QP203 of your textbook for details. Draw the donut graph, of employees vs. Bi-Weekly net pay. Insert the graph into the spreadsheet. Print and submit the as displayed and the cells formula version of the spreadsheet.

Also Submit: