1 / 22

Google Sheets

Google Sheets. Google Sheets is a spreadsheet program You can create charts of your information so that it can be quickly and easily understood It is Free to use Similar to Microsoft Excel. Getting Started. 1. 2. From the Google homepage, select Drive. Getting Started. Click on New

dcosta
Download Presentation

Google Sheets

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Google Sheets • Google Sheets is a spreadsheet program • You can create charts of your information so that it can be quickly and easily understood • It is Free to use • Similar to Microsoft Excel

  2. Getting Started 1 2 From the Google homepage, select Drive

  3. Getting Started Click on New Select Sheets

  4. Spreadsheets ROW (Horizontal) Spreadsheets consist of columns (vertical) and rows (horizontal) The intersection of a row and column is called a CELL COLUMN (vertical) Letters indicate COLUMNS and Numbers indicate ROWS

  5. Spreadsheets A Row is a group of cells that run horizontally. Rows are numerically labeled A Column is a group of cells that run vertically. Columns are alphabetically labeled. Cells are the intersection of a Row and Column Cells are identified by first stating the intersecting column letter followed by the intersecting Row number For example, B2 is an example of a cell address

  6. Charts are used to show information so that it can be easily understood Types of Charts Line Graph Column or Bar Graph Pie Graph

  7. Chart Title Chart Components Values Axis (Y–axis) Legend Category Labels Category Axis (X-axis)

  8. Toy Sales Activity(Creating a chart) Follow the steps on the next slides…

  9. If you make a mistake simply click the Undo Button

  10. Step 1: Type these words and numbers into the cells in a Google Sheet

  11. Step 2 • Select all the cells by starting in cell A3 • Hold down your left mouse button and drag across and down until you have selected just the 8 cells • Make sure you have not highlighted any other cells than these 8 Cells Cell A3 Start Here

  12. Step 3 Go to Insert - Chart

  13. Step 4 • Click this Pie Chart • Press Insert

  14. Step 5 • The Pie Chart will be placed into your Google Sheet • Drag it over so it is not covering up your other information

  15. Step 6 Go back and follow the steps again to create 2 other types of Charts Don’t forget to highlight the 8 cells! 2 Other Charts

  16. Title Step 7: Click here to change the title to Toy Sales

  17. Google Sheets Print Borders Chart Functions Align Undo Font

  18. Activity #2 Type these words and numbers into the cells in a Google Sheet Create 3 Charts Title the Sheet - Halloween Treats Look at the next slide for hints…

  19. Hint: Highlight all of these 12 cells

  20. Specializing in PowerPoint presentations that share cutting edge technology and examine revolutionary businesses Link to store http://www.teacherspayteachers.com/Store/Gavin-Middleton

  21. Thank you for downloading this PowerPoint • I hope that you and your students enjoyed it! • If you provide Positive Feedback and Follow Me, I will send you a Free Lesson of your choice ($4 or less value). • E-mail me at gavin@eastdalebusiness.com to receive your free PowerPoint. To view or purchase more materials here is a link to my store http://www.teacherspayteachers.com/store/gavin-middleton

More Related