Accessibility tab summary: Students please use the information below to complete the question completing the required cells. Given information for this question is presented in rows $2$ through $15.$ The required answers are in rows $17$ through $37.$

Sgt$.$ Barnes is a veteran police officer and has been asked to sit for the Lieutenant's exam. She is excited about the opportunity as it is the natural progression of her career along with a great pay raise. However, Sgt$.$ Barnes also moonlights as a private security guard for major sporting events and is concerned the promotion and raise will have an adverse impact on her marginal tax rate. Sgt$.$ Barnes would like to know what the tax implication will be with the promotion and raise. Presented below are her current and proposed salaries along with her net income as a private security guard. For purposes of this problem, ignore any self$-$employment implications.

Required:

$1.$ Complete the "The tax is:$"$ column for each filing status table using a formula.

$2.$ Prepare the Current Salary and Proposed Salary tax calculations using VLOOKUP formulas to the $2024$ tax brackets.

$3.$ Enter a formula to compute the Marginal Tax Rate $($Hint: $\backslash$Delta Tax$/\backslash$Delta Taxable Income$)$

Note: Use the TRUE logical value for VLOOKUP formulas.