Temperature

Directions

Use the following guidelines to create a line graph of average temperatures in three major cities.

  1. Go to Workgroup — Classes — CompApps — Calc and open a copy of Temperature and save a copy in your CompApps folder.
  2. In cell A1, type “Average Temperatures” in bold text. In cell A2, type “Prepared by” with your name.
  3. In cells A4:D16, type the table of numbers as shown in the example.
  4. Bold, center, and add borders as shown.
  5. Adjust the column widths, making sure to keep columns B-D the same width.
  6. Add the table of statistics in cells A18:D21, using formulas with functions to compute the numbers.
  7. Format text and numbers as shown in the example.
  8. Highlight cells A4:D16 and click the Chart Wizard button.
  9. Step 1: Select “Line” chart type and use the “Points and Lines” sub-type (not stacked line).
  10. Click on Step 4 and set the chart title to “Average Temperatures” and the Value (Y) axis label to “Degrees (Celcius).” Change the legend placement to Top and click Finish.
  11. Format the Plot Area and make the background white. Format each of the plots to make the lines thicker to 0.10 inches. Change the lines and markers for Houston to red, Seattle to blue, and Minneapolis to green.
  12. Make sure the page orientation is set to landscape.
  13. Page preview and return to the normal view. Using the handles, resize the chart so that it fills the remainder of the page and everything fits on one page. Page preview again to verify that it fits and fills the page.
  14. Save the modified file.
  15. Raise your hand and ask your teacher to grade your spreadsheet on screen.

Example