Thinkabara

☁️ Google Tools for Students · Lesson 5 of 7

Google Sheets

Google Classroom

A table, your first formula, sorting and a chart.

Cells, rows and columns

A spreadsheet is a grid. Columns have letters (A, B, C), rows have numbers (1, 2, 3), and each box is a cell with an address like B3. Open sheets.new to start.

Your first formula

  1. Type numbers in B2 to B6 — say, minutes you read each day
  2. Click B7 and type =SUM(B2:B6), then Enter
  3. In B8 type =AVERAGE(B2:B6)
  4. Change a number and watch the results update by themselves

Sorting

Select the table, then Data > Sort range > check “Data has header row” and choose the column to sort by, A→Z or Z→A. Freeze the first row (View > Freeze > 1 row) so the headers stay visible while you scroll.

A chart

Select the data, including headers, and click Insert > Chart. Sheets picks a chart; in the Chart editor on the right you can switch to a column, line or pie chart and change the title.

Tip

💡 Every formula starts with =. Without it, Sheets thinks you typed text.

✏️ Practice: your turn

  1. Make a sheet of the minutes you read this week
  2. Add SUM and AVERAGE formulas
  3. Sort the days from most to least minutes
  4. Make a column chart and give it a title

🧠 Quick quiz

Answer all 4 questions correctly to mark this lesson as done.

1. What is B3?
2. How does every formula start?
3. What does =AVERAGE(B2:B6) do?
4. Where do you make a chart?

0 of 4 correct

All lessons in Google Tools for Students

  1. 📁 1. Google Drive and foldersWhere files are saved, a folder for each subject and uploading files
  2. 📄 2. Google DocsA new document, formatting, voice typing and version history
  3. 🤝 3. Sharing and group workViewer, commenter or editor, a link, and working together live
  4. 💬 4. Comments and suggestionsComment on a sentence, suggesting mode, and tagging a friend
  5. 📊 5. Google SheetsA table, your first formula, sorting and a chart
  6. 📝 6. Google FormsA survey, a quiz with points, and answers that land in a sheet
  7. 🏫 7. Google ClassroomJoin a class, open an assignment, attach a file and turn it in