11. Save the Summary workbook. 12. The office manager for the Midwest Cubed Ice location found a…

11. Save the Summary workbook.

12. The office manager for the Midwest Cubed Ice location
found a newer workbook

for that location’s sales and commissions, and has submitted
it to you. Close the Cubed Ice

Midwest workbook that you have been working with, open the
New Midwest workbook located

in the Excel6 _ Case4 folder included with your Data
Files, and then save the workbook as

New Midwest 2016 in the location specified by your
instructor. Use Update Links to update the

totals on the Summary worksheet in the Cubed Ice Summary
workbook. The Totals before the

update are Gross Sales $5

11. Save the Summary workbook.

12. The office manager for the Midwest Cubed Ice location
found a newer workbook

for that location’s sales and commissions, and has submitted
it to you. Close the Cubed Ice

Midwest workbook that you have been working with, open the
New Midwest workbook located

in the Excel6 _ Case4 folder included with your Data
Files, and then save the workbook as

New Midwest 2016 in the location specified by your
instructor. Use Update Links to update the

totals on the Summary worksheet in the Cubed Ice Summary
workbook. The Totals before the

update are Gross Sales $5,155,415; Bonus Sales $2,502,265;
and Bonus Amount $125,133. The

totals after the update are Gross Sales $5,155,415; Bonus
Sales $2,502,265; and Bonus Amount

$209,478.