Part $2(70\%)$:

Below are the $2024$ tax brackets for single American taxpayers:

$\backslash$table$[[$Tax rate,Single,Married filing jointly$],[10\%,$$$0$ to $$11,600,$$$0$ to $$23,200],[12\%,$$$11,601$ to $$47,150,$$$23,201$ to $$94,300],[22\%,$$$47,151$ to $$100,525,$$$94,301$ to $$201,050],[24\%,$$$100,526$ to $$191,950,$$$201,051$ to $$383,900],[32\%,$$$191,951$ to $$243,725,$$$383,901$ to $$487,450],[35\%,$$$243,726$ to $$609,350,$$$487,451$ to $$731,200],[37\%,$$$609,351$ or more,$$731,201$ or more$]]$

a$)$ Build this table in Excel. Have the 'user' select their marital status $($single or married filing jointly$)$ from a data validation list which you should have in a cell.

b$)$ Have the 'user' also plug in their salary into a cell.

c$)$ In another cell, use a lookup function to determine and output the marginal tax rate based on their status and salary.

Note: the marginal tax rate is defined as the tax rate that applies to the last unit of the tax base. For example, if your income is $$25,000,$ your marginal tax rate is $12\%.$ Your lookup function should be flexible enough to output the correct answer for a multitude of different salaries.

d$)$ Build a lookup function that calculates the amount of tax owed, for any given salary. For example, if you are single and your income is $$25,000$ the tax owed is: of $(25,000-11,600)$ total tax owed. $($Please help me solve letter D in excel please$)$