Grade 9 Information Technology unit 3
Copying a formula: which cells move, which stay
4 min · 2 past exam questions worked through
Parts of the lesson
Tap a part to play the lesson from there.
A 4-minute Temari video lesson on Grade 9 Information Technology unit 3: Copying a formula: which cells move, which stay. Free to watch, no account needed.
More on unit 3
The chapter's own page holds the rest of what Temari has on it, such as short notes and practice questions with their answers.
Open the unit 3 pageEverything the lesson says
The lesson's words, part by part. Tap a time to play the lesson from there.
0:00Introduction
In a spreadsheet, you write a formula once, then copy it down a whole column. But when you copy it, the formula changes. Learn which parts change, and which part you can lock, and your totals will come out right.
0:13Formulas and cell references
First, the basics. In Excel, every formula starts with an equal sign. A cell reference names a cell by its column letter and its row number. B2 is column B, row two.
Say columns B to E hold one student's marks. Cell F2 adds them up: equals B2 plus C2 plus D2 plus E2. Why use references and not the numbers themselves? Because if a mark changes later, the formula updates automatically.
0:47Relative references move
Now copy F2 down for the next students. Drag the fill handle, the small square at the bottom right corner of the cell. Excel copies the formula, but not exactly.
In F3, it becomes B3 plus C3 plus D3 plus E3. In F4, B4 plus C4 plus D4 plus E4. The formula moved down one row, so every reference moved down one row too. These are relative references. They change relative to where you copy the formula, and that is what Excel does by default.
1:24Practice question 1Past exam
Here is a practice question. In Microsoft Excel, which symbol must be typed at the beginning of every formula? Pause the video, and try it.
Every formula starts with an equal sign. That is how Excel tells a formula apart from ordinary data. The answer is A. The plus sign is for adding. The hash mark is not one of Excel's operators in your book. And the dollar sign does have a job in formulas. You will see it next.
1:59Absolute references stay
But sometimes one cell must stay put. Say cell B9 holds a bonus mark, the same for every student. You add it in F2, then copy down. In F3, B9 would become B10, the wrong cell.
So you lock it. Type a dollar sign before the column letter and before the row number: dollar B, dollar nine. Or select it and press F4. This is an absolute reference. It stays the same wherever you copy the formula, while the other references still move.
2:36Practice question 2Past exam
Try this one. A student types the formula, equals B2 plus C2 plus D2 plus E2, in cell F2, to calculate total marks. When this formula is copied down to cell F4 using the fill handle, what will the formula in cell F4 be? Pause, and try it.
From F2 to F4 is two rows down. So every relative reference moves two rows down. B2 becomes B4, C2 becomes C4, and so on. The answer is A. B is the formula unchanged, but relative references move. C has dollar signs that nobody typed. And D adds up the wrong cells.
3:26Summary
So remember. Every formula starts with an equal sign. When you copy a formula, relative references move with it, row for row. A dollar sign before the column and the row makes a reference absolute, so it stays put. Keep practising questions like these on Temari.et.
Practise this unit in the app
Temari turns this chapter into timed practice and marks it as you go, with an AI tutor to explain anything that did not land.
Start freeTemari.et is also an Android app, free on Google Play.

