A company has prepared a spreadsheet that contains 3 years of sales projections for its four sales groups: electronics, computers, appliances, and furniture. Several rows of this spread-sheet are illustrated.

Required Download the spreadsheet file titled “chapter_ 8_ 66” from the textbook Web site and prepare a summary analysis of these projections by group for the 3 years in the following format:

This task can best be accomplished by using the SUMIFfunction.

Transcribed Image Text:

Sales Projections by Group/Category 2012 Group Category in dollars) (in dollars) (in dollars) 1.750,000 1.500,000 1.450,000 2013 2014 Electronics Televisions Computers Laptop Appliances Kitchen Furniture Family Room 1230,000 2.500.000 2,100.000 1,880,000 1,500,000 3,250,000 2.850,000 2,005,000 1.700,000 Sales Projections by Group Group 2012 2013 2014 3 Year Total Appliances Computers Electronics Fumiture Totals by Year