b. Calculate the Bonus Sales for each month using the formula Gross Sales – Target. (A bonus will be

b. Calculate the Bonus Sales for each month using the
formula Gross Sales – Target. (A bonus

will be paid only on sales over this amount.) If the
salesperson did not sell more than the

target, he or she receives no bonus. (Hint: Use an IF
statement and absolute cell references.)

c. Calculate the Bonus Amount using the formula Bonus Sales
* Bonus Rate. (Hint: Remember to

use absolute cell references.)

d. Enter Total in cell A16. Total the Gross Sales, Bonus
Sales, and Bonus Amount.

e. Bold the ranges A4:A16 and B3:D3. Wrap the text and
center the range B3:D3. Display

all numbers with

b. Calculate the Bonus Sales for each month using the
formula Gross Sales – Target. (A bonus

will be paid only on sales over this amount.) If the
salesperson did not sell more than the

target, he or she receives no bonus. (Hint: Use an IF
statement and absolute cell references.)

c. Calculate the Bonus Amount using the formula Bonus Sales
* Bonus Rate. (Hint: Remember to

use absolute cell references.)

d. Enter Total in cell A16. Total the Gross Sales, Bonus
Sales, and Bonus Amount.

e. Bold the ranges A4:A16 and B3:D3. Wrap the text and
center the range B3:D3. Display

all numbers with a comma and no decimal places. Display the
total row values (the range

B16:D16) with a dollar sign.

f. Ungroup the worksheets.