Problem

Excel® Assignment: Sales Projection TotalsA company has prepared a spreadsheet that contai...

Excel® Assignment: Sales Projection Totals

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 spreadsheet are illustrated.

Sales Projections by Group/Category

Group

Category

2012 (in dollars)

2013 (in dollars)

2014 (in dollars)

Electronics

Televisions

1,750,000

2,500,000

3,250,000

Computers

Laptop

1,500,000

2,100,000

2,850,000

Appliances

Kitchen

1,450,000

1,880,000

2,005,000

Furniture

Family Room

1,230,000

1,500,000

1,700,000

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:

Sales Projections by Group

Group

2012

2013

2014

3 Year Total

Appliances

 

 

 

 

Computers

 

 

 

 

Electronics

 

 

 

 

Furniture

 

 

 

 

Totals by Year

 

 

 

 

This task can best be accomplished by using the SUMIF function.

Step-by-Step Solution

Request Professional Solution

Request Solution!

We need at least 10 more requests to produce the solution.

0 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the solution will be notified once they are available.
Add your Solution
Textbook Solutions and Answers Search