Given the following raw data, make a spreadsheet to clearly show the sales in each region for each period. You should put the data into two dimensions so that you can compare one region to another, and one period to another. You should show totals for each region, each period, and the overall total. You should use borders and shading to make a professional looking report.
 

Region Period Sales South 4 500 East 3 120 South 2 334 East 4 144 South 3 422 Midwest 1 233 Midwest 2 267 East 2 134 Midwest 3 289 Midwest 4 255 South 1 433 East 1 121

Note: The sales figures have been compiled from various sources, and have been written down in no particular order! Hint: If you find yourself entering a label, such as "South," more than once, you are not approaching the problem correctly! Hint: Your spreadsheet should look nothing like the table to the left, except that it will contain the same information.

Next, you will make some charts to add to the report. First, make a pie chart to show how each region contributes to the total sales for the year. Second, make a line chart to show how the total sales progress from quarter to quarter. Third, make a bar(column) chart to both compare the sales of the regions for each quarter, and show the progression of sales from quarter to quarter. Place the charts on the spreadsheet.

Finally, use Page Setup… to put your name in the right section of the Header, and print the report.