This excel file protected excel file

1. (10 points) Write a formula for the Gross Pay column for each employee using the “IF” function:
   a. 40*(Rate per Hour)+(Hours Worked-40)*1.5*Rate per Hour if Hours Worked is larger than 40;
   b. Rate per Hour*Hours Worked if Hours Worked is less than or equal to 40.

2. (10 points) Enter the value of the Federal Tax Rate at B17 as the first two digits of your University ID in percentage. For instance, if your ID is 1234567 than enter 12%.

7. (10 points) Calculate the total, average, highest and lowest values of Withholding Allowances, Gross Pay, Federal Tax, State Tax and Net Pay in the labeled rows.

8. (10 points) Create a Sparkline chart at I15 by using the data in the Net Pay column (excluding the total, average, highest and lowest values)

You should do this by your own. All steps of this homework should be only completed by you. Please submit (upload) only you excel file. Any other file format or screenshots will not be accepted. We wish you success.