Revenue

Directions

Use the following guidelines to create a bar graph of Pella Corporation window sales revenue in major cities.

  1. Go to the Workgroup — Classes — CompApps — Calc and open a copy of Revenue and save a copy in your CompApps folder.
  2. Bold cell A1. Update cell A3 to include your name.
  3. Select A6-C14, and Sort Column B by Ascending.
  4. Format the table in cells A5:C14 as shown in the example. Be sure to use currency with no decimals.
  5. Add borders above and below the table.
  6. Add the totals line as shown in the example, using formulas to compute the numbers. Format as shown.
  7. Highlight the table (but not the totals) and click the Chart Wizard button.
  8. Step 1: Select the first “Column” chart type and check for “3D look” then move to step 4 of the Chart Wizard.
  9. Step 4: Set the chart title to “Sales Revenue.” Set the Y-Axis Title to “Millions.” Change the legend placement to Bottom. Click Finish.
  10. Change the page orientation to landscape.
  11. Page Preview and close the preview to see the print boundaries. Then move and enlarge the chart so it fits on and fills the page.
  12. Change the colors of data series to light green and light blue. Change the background color of the chart (Chart Wall) to be a gradient.
  13. Format the X Axis, so that the text is at a 45-degree angle (and is overlapped) under the Labels tab.
  14. Save the modified file.
  15. Raise your hand and ask your teacher to grade your spreadsheet on screen.

Example