This is for an excel spreadsheet class and I need help! This is the scenario and needs to be done Here is the problem below

 

You have the following employees who worked the hours at the rates shown.

All pay a flat rate of 31% for deductions.

Use Excel to create and complete the worksheet.

You must use formulas to compute GROSS, DEDUCTIONS and NET.

Remember that money cells should display with two decimal places.

You must also create a pie graph that associates NAME with NET.

NAME	HOURS	RATE	GROSS	DEDUCTIONS	NET
Floyd, Pink	36	8.65
Zeppelin, Led	20	12.98
Martin, Dean	35	20.00
Doe, John	40	15.65
Ames, Jasper	38	14.32

In a different area of the same worksheet, create and complete the following worksheet.

You will need to appropriately use the following functions:

       (Hint: return the word Pass in quotes if average is 60 or above)

(average cell>= 60,”Pass”,”Fail”)

                     and       

Please use two decimal places for the averages.

STUDENT GRADES
NAME	Exam 1	Exam 2	Exam 3	Average	Pass/Fail
Linus	51	70	54	Fail
Sally	87	85	88	Pass
Lucy	89	92	75	Pass
Pigpen	56	40	53	Fail
Chuck	63	79	89	Pass
Highest
Lowest
Average
Count

Save the worksheet as Excel Exam, attach and submit through the appropriate assignment.