Spreadsheet 02: Numbers

Create the document  below and share to tawilliams@conroeisd.net
Period   |   Lastname, Firstname   |   Spreadsheet: Numbers

  • Create a Google Spreadsheet


  • Second Sheet: Create a Column Chart
    • Watch the video
      • Highlight the data
      • Press the "Insert Chart" button
        • "Switch rows / columns" must be checked 
        • "Use row 1 as headers" must be checked
        • Choose Column Chart (one of the four charts on the bottom left)
        • Press Insert
        • Click on chart
        • On the top right, press the arrow and choose "Move to own sheet"
      • Click Advanced Edit
      • Change "Chart Title" to "Color Beads"
        • Change "Horizontal Axis title" to "Colors"
        • Change "Left Vertical Axis Title" to "Number of Beads"
        • Change Colors to corresponding colors
      • Rename Chart to "Column Chart"

    • Third Sheet: Create a Bar Chart
      • Watch the video
      • Highlight the data
      • Press the "Insert Chart" button
        • "Switch rows / columns" must be checked 
        • "Use row 1 as headers" must be checked
        • Choose Bar Chart (one of the four charts on the bottom left)
        • Press Insert
        • Click on chart
        • On the top right, press the arrow and choose "Move to own sheet"
      • Click Advanced Edit
      • Change "Chart Title" to "Color Beads"
        • Change "Horizontal Axis title" to "Number of Beads"
        • Change "Left Vertical Axis Title" to "Colors"
        • Change Colors to corresponding colors
      • Rename Chart to "Bar Chart"

    • Fourth Sheet: Create a Line Chart
      • Watch the video
      • Highlight the data
      • Press the "Insert Chart" button
        • "Use row 1 as headers" must be checked
        • Choose Line Chart (one of the four charts on the bottom left)
        • Press Insert
        • Click on chart
        • On the top right, press the arrow and choose "Move to own sheet"
      • Click Advanced Edit
      • Change "Chart Title" to "Color Beads"
        • Change "Horizontal Axis title" to "Colors"
        • Change "Left Vertical Axis Title" to "Number of Beads"
        • Change Color to Red
      • Rename Chart to "Line Chart"

    • Fifth Sheet: Create a Pie Chart
      • Watch the video
      • Highlight the data
      • Press the "Insert Chart" button
        • "Use row 1 as headers" must be checked
        • Choose Pie Chart
          • Go to Charts - Pie - Pie chart
        • Press Insert
        • Click on chart
        • On the top right, press the arrow and choose "Move to own sheet"
      • Click Advanced Edit
      • Change "Chart Title" to "Color Beads"
        • Change Colors to corresponding colors
      • Rename Chart to "Pie Chart"

    Posted by at