የ9ኛ ክፍል የመረጃ ቴክኖሎጂ ምዕራፍ 3
Copying a formula: which cells move, which stay
4 ደቂቃ · የተሠሩ 2 ያለፉ የፈተና ጥያቄዎች
የትምህርቱ ክፍሎች
ትምህርቱን ከዚያ ጀምሮ ለማጫወት አንድ ክፍል ይንኩ።
የ9ኛ ክፍል የመረጃ ቴክኖሎጂ ምዕራፍ 3 የ4 ደቂቃ የ Temari ቪዲዮ ትምህርት፦ Copying a formula: which cells move, which stay። 2 ያለፉ የፈተና ጥያቄዎችን ደረጃ በደረጃ ይሠራል። በነጻ ይታያል፤ መለያ አያስፈልግም። ትምህርቱ በእንግሊዝኛ ነው።
ስለ ምዕራፍ 3 ተጨማሪ
የምዕራፉ ገጽ Temari በዚህ ምዕራፍ ላይ ያለውን ሌላውን ይዟል፤ ለምሳሌ አጭር ማስታወሻዎችና የመልመጃ ጥያቄዎች ከመልሶቻቸው ጋር።
የምዕራፍ 3 ገጽ ይክፈቱትምህርቱ የሚናገረው ሁሉ
የትምህርቱ ቃላት በየክፍሉ። ትምህርቱን ከዚያ ጀምሮ ለማጫወት ሰዓቱን ይንኩ።
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 1ያለፈ ፈተና
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 2ያለፈ ፈተና
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.
ይህን ምዕራፍ በመተግበሪያው ይለማመዱ
Temari ይህን ምዕራፍ ወደ ጊዜ የተቆረጠለት መልመጃ ይለውጠዋል፣ እየሠሩ ያርምዎታል፤ ያልገባዎትንም የሚያብራራ የ AI አስተማሪ አለ።
በነጻ ይጀምሩTemari.et ለ Android ስልኮች መተግበሪያ አለው፤ በ Google Play ላይ በነጻ ይገኛል።

