Open a blank worksheet in Excel. Enter the First name, Last Name, Gender, Department, and Yearly Salary $($use salaries that are greater than $$75,000)$ for $10$ fictitious people in Columns A$-$E Beginning in Row $2.$ Be sure to enter column headings $($Row $1)$ and align them with the data. Adjust column widths as needed.

Sort the data by Last Name.

Insert a column before the name $($new column A$),$ and enter the Employee Number. Type in $1001$ and $1002$ for the first two employees only, then select both the numbers and copy down using autofill.

In Column G$,$ type the heading "Tax Withheld", and enter a formula that computes it$.$ Assume $20\%$ of the salary is withheld for taxes.

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$.$

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$ bac If you had $$20,000$ or more withheld, you get $$2,000$ back as before. Use a VLOOKUP stateme to compute the New Tax Break in Column I.