What the formula/ IF & vlookup Function for Incone Tax, Salary After Tax and Annual Salary $35,000?

1. Using Sales targets, add a new worksheet and name it Tax table 2. Use the Series feature to create the Lookup table shown below. to emon of ! velquib of whom TAX TABLE Annual Salary $35,000 Income Tax in Salary After Tax Annual Salary Tax 10000 10% 20000 13%| orus slomo doodshow works 30000 16% 40000 19% 50000 22% wunod asis? 60000 25% 70000 28% 80000 31% 90000 34% 100000 37% 110000 40% 3. In the Income Tax cell use the vlookup function that will return the tax percentage on the Annual Salary. 4. Calculate the salary after tax. 5. Print the Tax Table worksheet. 6. Save and close the workbook