What is Google Sheets?

For subtitles, click on the caption option above

Accessing Google Sheets

For subtitles, click on the caption option above

HIGHLIGHTS

  • Sign in to your Google Account
  • Go to sheets.google.com

Creating a Google Sheet

For subtitles, click on the caption option above

HIGHLIGHTS

  • Click the colorful icon to create a new Sheet
  • Enter student names and grades in two different columns

Sorting and Organizing Data

For subtitles, click on the caption option above

HIGHLIGHTS

  • Organize and sort data by using the column drop-down menu
  • Click the Sigma button and choose "Average" to get a group grade average

Filtering Data

For subtitles, click on the caption option above

HIGHLIGHTS

  • Highlight cells with the data you want to filter
  • Click Filter in the toolbar
  • Click the Filter lines at the top of the cell
  • Choose your filtering options

Editing a Google Sheet

For subtitles, click on the caption option above

HIGHLIGHTS

  • Change fonts, type size, type color, and more using the toolbar options
  • Format numbers into currency, percentages, decimals, and more using the toolbar options
  • Click the Function button to access special formulas

Creating Charts and Graphs

For subtitles, click on the caption option above

HIGHLIGHTS

  • Highlight cells containing the data you want to graph
  • Select Chart from the Insert menu
  • Customize your chart or graph using the Chart Editor

Sharing a Google Sheet

For subtitles, click on the caption option above

HIGHLIGHTS

SHARE

  • Click the Share button
  • Enter an email address
  • Set a permission level

SHARE A PUBLIC LINK

  • Click the Share button
  • Click "Get a shareable link"
  • Choose "Anyone with the link"
  • Set permission level to "Can view"

Reviewing the Basics

Google Sheets

Now that we've gone over some of the basics of Google Sheets, let's review.

When you're ready to put your new skills to the test, click below to start your knowledge check.

Test your knowledge

Reviewing the Basics

Google Sheets Quiz

1: True or False: Only numbers can be sorted in a Sheet.

Correct!

Submit Next
close

That's incorrect.

You can sort data by name and number value in
Google Sheets.

Next

Reviewing the Basics

Google Sheets Quiz

2: Which of the following are types of charts or graphs available in Sheets? Check all that apply.

Correct!

Submit Next
close

Whoops, that's incorrect.
You can create all kinds of charts and graphs in Sheets, including:

  • Line
  • Scatter
  • Pie
  • Bar
  • Map
  • Histogram
  • Area
  • Organizational Chart
Next

Reviewing the Basics

Google Sheets Quiz

3: Choose the correct order to create a chart in Google Sheets.

Correct!

Submit Next
close

Sorry, the correct order is:

  • 1.  Create a new Sheet
    2.  Enter your data
    3.  Highlight the data you wish to represent in a graph
    4.  Click the Insert Chart icon
    5.  Use the Chart Editor to customize your chart or graph
Next

Great job! Now you know the basics of Google Sheets.

product icon

HERE'S WHAT YOU LEARNED TODAY:

  • What Google Sheets is
  • How to access Google Sheets
  • How to create a Google Sheet
  • How to sort, filter, and edit data
  • How to create charts and graphs
  • How to share a Google Sheet

Want to keep learning?
Review the lessons on Google Sheets in our Teacher Center.

Restart Lesson 6

See you next week for Lesson 7: Google Drawings

Google for Education logo
Privacy Terms of Use