deductions.1.10 Use an IF function with nested VLOOKUP functions to cafcutate the Federal Income Tax Rate.a. The federal tax rate is a function of the adjusted income and the employee's marital status.b. Reference the tax tables in the Model Assumptions and the marital status in the Empioyee information section to construct a formula (set of nested formulas) to calculate the tax rate.c. For example, a single employee who earned $15,000 would pay a 33% marginal tax rate.71.11 Calculate the federal1.12 Calculate the tax1.13 Calculate the net federal100**MyEducator Tasks1.11 Calculate the federal income tax.The federal income tax is the adjusted income times the federal income tax rate calculated in cell 2.51.12 Calculate the tax1.13 Calculate the net federal1.14 Calculate the state115-Calculate the medicare1.16 Calculate the social1.17 Calculate the total taxes.Phone Plan AnalysisYou are planning to switch your cell phone provider. You have imported your data usage from the last six months with your previous provider and entered this information on the "Data"2.51.12 Calculate the tax adjustment for allowances. An employee will have less federal income tax withheld for every allowance that they claim. Allowances account for the number of dependents they will claim on their taxes and other factors that will ultimately reduce the amount of federal taxes they will pay.a. The adjustment for allowances is calculated as the product of the number of allowances (in the employee information section), the allowance deduction amount (in the model assumptions), and the employee Federal Income Tax rate (calculated in task 10).2.51.13 Calculate the net federal114 Calculate the state1.15 Calculate the medicare\table[[Employee Information],[Hours Worked,85],[Pay Rate,$30.00],[Marital Status,Married],[8 of Allowances,2],[Retirement Savings $,5 W],[Healthinsurance (everypaycleck),$125.00\table[[Rey het Coltudetions],[Iscume,],[Hours Werled,85],[Pary Rate,$30.00