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.
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.