Boqonnaa 3 Teeknooloojii Odeeffannoo kutaa 9
Copying a formula: which cells move, which stay
daqiiqaa 4 · Gaaffii qormaata darbe 2 hojjetaman
Kutaalee barnootaa
Barnoota achii jalqabee taphachiisuuf kutaa tokko tuqi.
Barnoota viidiyoo Temari daqiiqaa 4 boqonnaa 3 Teeknooloojii Odeeffannoo kutaa 9: Copying a formula: which cells move, which stay. Barnoonni kun Afaan Ingiliziitiin.
Dabalata boqonnaa 3
Fuulli boqonnaa kanaa wanta Temari boqonnaa kana irratti qabu kan hafe qaba, fakkeenyaaf yaadannoo gabaabaa fi gaaffii shaakalaa deebii isaanii waliin.
Fuula boqonnaa 3 baniWanta barnoonni jedhu hunda
Jechoota barnootaa kutaa kutaan. Barnoota achii jalqabee taphachiisuuf yeroo tuqi.
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 1Qormaata darbe
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 2Qormaata darbe
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.
Boqonnaa kana appii keessatti shaakali
Temari boqonnaa kana gara shaakala yeroon daangeffametti jijjiira; utuu hojjettuu ni sirreessa; wanti si hin galinis barsiisaa AI tiin ni ibsama.
Bilisaan jalqabiTemari.et appii Android qaba; Google Play irratti bilisaan argama.

