answer questions A-D at the bottom

Uving Excel to tind the manginal tax rate caa he accomplished uving the VL.oOKUP funetien Itrwever. calculating the total tax bill is a litte more dimeulh. Below we have shown a cony of the IRS tax table for an unmarried individual for 2020 . Orten. tax tables are prosented in this format. In reading this table, the maryinal cax ruce for taxable income leus than 59.875 is 10 percent. If the taxable income is between $9.875 and $40.125. the tax bill is $987.50 plus the marginal tuxes. Thic marginal taxes are calculated as the tixable incornc minus $9.875 times the marginal tax rate of 12 percent Below, we have the tax table that was applicable for married individuald filing jointly in 2020. In reading this table, the maryinal cax rate for taxable inconce less than $9.875 is 10 percent. If the taxable income is between $9.875 and $40,125, the tax bill is $987.50 plus the marginal taxes. The marginal taxcs are calculated as the taxable income minus $9,875 times the marginal tax rate of 12 percent. Below, we have the tax tahle that was applicahle for married indiviluals filing joinily in 2020. a. Create a tax table in Excel for a couple filing jointly similar to the individual tax table shown above. Your spreadsheet should then calculare the marginal tax rate, the average tax rate, and the tax bill for any level of taxable income input by a user. b. Fot- as sube income of $225,000, what is the marginal tax rate? c. Nos t s sabie income of $225,000, what is the total tax bill? d. For a saxible income of $225.000, what is the average tax rate