Excel: 3D Workbooks

Updated 2017.10.01

Open the Sales By Cityworkbook. All references below to "all three worksheets" below refer to the Sioux City, Omaha, and Des Moines worksheets.

  1. Save the file with the name SalesByCity-FirstName-LastName.xlsx using your first and last name.
  2. Change the color of the sheet tab for each worksheet: Sioux City:Red, Omaha: Green, Des Moines:Blue (not Light Blue or Dark Blue). Use colors from the Standard Colors palette.
  3. In F3 through F8 on all three worksheets, put a formula that will sum the sales numbers for each product.
  4. In B9 through F9 on all three worksheets, put a formula that sum the corresponding column.
  5. In B9 through F9 on all three worksheets, format using the Total cell style.
  6. On all three worksheets, merge and center the text in A1 over columns A:F.
  7. On all three worksheets, change the cell style of cell A1 to theTitle style. Make sure that row 1 is tall enough for all of the text to be seen.
  8. On all three worksheets, change the cell style of all column headings (B2:F2) to Heading 3.
  9. On all three worksheets, change the cell style of A3:A9 to Heading 4.
  10. On all three worksheets, format all numbers with theAccounting Style and zero decimal places.
  11. On all three worksheets, change the font color(not the fill color) of cell A1 to match the tab color.
  12. Create a new worksheet called Summary and copy everything from the Sioux City worksheet to it.
  13. Move the Summary sheet to the left of the Sioux City worksheet.
  14. Delete B3:E8. Put formulas that will add all of the numbers on the other three worksheets and put the sums in the corresponding locations in your Summary worksheet.
  15. On the Summary worksheet, put Regional Sales in A1.
  16. [2 points] For all three worksheets plus the Summary worksheet, add a center footer that will display the page number and the total number of pages. For example: Page 2 of 4.
  17. For all three worksheets plus the Summary worksheet, set the page orientation to landscape.
  18. On all three worksheets plus the Summary worksheet, put your name in the right part of the header.
  19. On all three worksheets plus the Summary worksheet, center the worksheet horizontally on the print preview page.

Chart

  1. Create a column chart (clustered 2D) from the data on the Summary worksheet that has the month name (B2:E2) at the bottom, and the Total (B9:E9) represented by a bar. Do not include a bar for the Total column.
  2. Use the Move Chart button to put the chart on a separate worksheet.
  3. For the Plot Area (behind the bars), set the Fill Color to the Preset Gradient called Light Gradient – Accent 4.
  4. Change the title to Regional Sales.
  5. Change the y-axis title to Sales in Millions of Dollars.