hello I need help with the following assignment;

1. Open a blank worksheet in Excel. Enter the First name, Last Name, Gender, Department, and Yearly Salary (use salaries that are greater than $65,000) for ten fictitious people in Columns A-E, beginning in Row 2. Be sure to enter column headings in Row 1 and align them with the data. Adjust column widths as needed.
2. Sort the data by the Last Name.
3. Insert a column before the name (new column A), and enter the Employee number ID. Type in 1 and 2 for the first two employees only, then select both and copy down for autofill.
4. In Column G, type the heading "Tax Withheld," and enter a formula that computes it. Assume 20% of the employee's salary is withheld for taxes.
5. The new tax code gives a Tax Break of $2,000 for all those who have more than $20,000 withheld in column G. Use an IF statement to compute this in Column H.
6. Assume now that the Tax Break is more complex than the previous step. If you had a least $10,000 withheld, you get $500 back. If you had at least $15,000 withheld, you get $1,000 back. If you had $20,000 or more withheld, you get $2,000 back as before. Use a VLOOKUP statement to compute the New Tax Break in Column I.
   • Using the following table:

Amount withheld	New tax break
0	0
10000	500
15000	1000
20000	2000

1. Draw a bar graph showing the salaries for each person, along with their last name. Label the axis appropriately.
2. Insert a new row right after all 10 row of data; use Excel formula to find the AVERAGE salary of all persons
3. Insert a new row right after average salary of all persons; use Excel formula to find the MEDIAN salary of all persons.
4. Sort the data by gender and insert a new row right after Median salary of all employees; use the Excel function to find the sample standard deviation (hint: the excel standard deviation function is STDEV.S not STDEV.P) of the female salaries.
   • Given that these ten people are a sample of the employees in your company, explain why you would use STDEV.S instead of STDEV.P?