d. Enter formulas in row 6 and copy down. Use the range names in cells B1, B2 and B3 instead of absolute cell references in the formulas.

e. C6 Bonus Amt: Use an IF formula to determine the bonus. If the salesperson sold more than 40,000, they get a bonus based on the amount in cell B2. If they didn't sell more than 40,000, they get 0 bonus.

f. D6 Gross Pay: add the bonus amount and the base pay

g. E6 Net Pay: GrossPay - tax amt. Within this formula you must calculate the tax amount and subtract it from the GrossPay. The tax amount is calculated by taking the tax rate times the gross pay.

h. F6 Message: If the salesperson got a bonus, they message should read: "Good Job!". If they did not get a bonus, the message should read "Work Harder!" i. Conditional Formatting: In column C, use conditional formatting to make bonus amounts display in red. The zero bonus amounts should stay black.

Base Pay:	2,000
Bonus Rate:	3%
Tax Rate:	8%
Salesperson	Sales Amt	Bonus Amt	Gross Pay	Net Pay	Message
Amy	40,000
Bob	35,000
Cathy	20,000
Don	50,000
Ellie	65,000
Frank	15,000
Gerta	22,000
Henry	55,000