In order to include an input box for Tom to make the percentage adjustments, you realize you need to add an additional row above Table $1.$ By adding an additional row, the range placement for Table $1,$ starting with the Representatives label changes to A$5$:F$25.$ The What$-$If label is now placed in cell G$5.$

a$.)$ In cell G$4$ include a label, enter it exactly as you see it including the formats: $*$What$-$If Increase :

Change the font size to $9.$

b$.)$ Include a fill color for range G$4$:H$4$ use; Blue, Accent $1,$ Lighter $60\%.$ Include an $$all borders$$ around this same range.

Cell H$4$ will work as the percentage input box.

$5.)$ Calculate what would happen if each sales representative increased their sales by $20\%.$ Use the input box you created in $4$b$,$ to plug in the $20\%.$ You will need to format the cell $($H$4$ so that the increase appears as: $20\%).$

a$.)$ Use absolute referencing to assist you with this calculation. Remember Tom needs to see the sales figure with a $20\%$ increase.