Grade 8 · Media & Informatics
Organise data in a spreadsheet and use simple formulas.
A spreadsheet organises data in a grid of rows (going across) and columns (going down). Where a row and a column meet is a cell, and each cell has an address made from its column letter and row number — for example B3. This grid makes it easy to line up and compare information, such as names and test scores.
The real power of a spreadsheet is formulas. A formula calculates for you and updates automatically when the numbers change. The most common is SUM, which adds a range of cells — for instance =SUM(B2:B6) adds everything from B2 down to B6. Change one of those cells and the total recalculates on its own.
Spreadsheets are used everywhere data needs sorting, totalling and charting — budgets, timetables, scores, experiments. Learning to label your columns clearly and let formulas do the arithmetic saves time and prevents mistakes.
Have a go right here. Nothing is saved and you can retry as much as you like. Create a free account when you want to save your progress and get Archie, your tutor.
Create a free account to save your progress, track mastery and ask Archie, your tutor, for a hand.
Already with us? Open this lesson in learncoach.ch for mastery tracking and Archie, your tutor.