Computer · lesson 28 of 30 · free

Spreadsheet basics — Computer worksheet

A spreadsheet is a table of rows and columns for numbers. Columns are named with letters (A, B, C …) and rows with numbers (1, 2, 3 …). The box where a row and column meet is a cell, and its address is the column letter and row number, like B3. A formula starts with = and works out an answer from other cells: =A1+A2 adds them, =SUM(A1:A3) adds a range.

▶ Watch how it works

Got it? Practise ↓

Remember

Letter, then number — “a cell address is the column letter, then the row number”

  1. Columns have letters, rows have numbers; a cell address is letter then number, like B3.
  2. Every formula starts with =. =A1+A2 adds two cells; =A2-A1 takes one away; =SUM(A1:A3) adds A1, A2 and A3.
  3. A range like A1:B3 has 2 columns × 3 rows = 6 cells.

Use it for: Class 5 computer lessons on spreadsheets, making a marks table and adding up a class budget.

Worked example: 📊 Cell A1 has 12 and cell A2 has 25. What does the formula =A1+A2 show? → 37

  1. =A1+A2 adds the number in A1 and the number in A2.
  2. 12 + 25 = 37.

Check: 37 − 25 = 12 ✓

▶ Watch it animated

✏️ Practice

Read the question, think about the computer at home or school, then tap your answer. Stuck? Press “Show me how”.

Right: 0 · Tried: 0

🏁 Lesson 28 test

20 questions. Check each answer, then go to the next one. Get 16 or more right to pass.

🏅 Sign in with Google to earn the 📊 Spreadsheet Star badge when you pass — and a certificate when you finish all 6 lessons of Part 5 · Class 5 Computer. You can still take the test without signing in.

🖨️ Class 5 Computer Worksheet: Spreadsheet Basics

✨ Free AI tutor

Ask the AI tutor about this lesson

Why does it work? When should you use it? Ask in English, मराठी or हिंदी.

Sign in with Google to ask Free — 20 questions a day.

👩‍🏫 Computer classes near you — online or at home

Prefer a real teacher? TalentJR teachers take live online classes anywhere in India and visit homes in selected cities. Tell us what you need and our team will call you with timings and fees.

Live online classesSmall groups or 1:1 with a teacher, from home, any city.
Teacher at homeA TalentJR teacher visits your home (selected cities).
At a centreClasses at a TalentJR partner centre near you, where available.
Badges, certificates & gifts A badge for every lesson you pass, a certificate for every part you finish, plus TalentJR Points for daily practice. Typing game Practise the keyboard — catch the falling words.