Relative Reference ni aina ya cell reference ambayo inabadilika wakati formula ikikopishwa kwenye seli nyingine. Hii ni muhimu unapohitaji formulas zinazorudiwa kwenye safu au kolon tofauti za data.
📘 Mifano ya Relative Reference
1️⃣ Formula Rahisi
Formula: =A1+B1
Kielelezo:
| A | B | C |
|---|---|-------------|
| 10 | 5 | =A1+B1 → 15 |
| 20 | 8 | Ukikopi formula → 28 |
Kwenye seli ya pili, formula inabadilika moja kwa moja kuwa =A2+B2 – hiyo ndiyo relative reference.
2️⃣ Faida
Inarahisisha kazi kwenye data nyingi.
Huwezi kuhitaji kuandika formulas mpya kila row au column.
🔗 Links Za Kujifunza Zaidi
🌐 Faulink Official Website:
https://www.faulink.com/
📘 Excel Mifumo – Ready to Use:
https://www.faulink.com/excel_mifumo.php
📲 Piga / WhatsApp kwa msaada wa haraka:
https://wa.me/255693118509
🧩 Hitimisho
Kuelewa Relative Reference kunarahisisha kazi yako kwenye Excel, hasa unaposhughulika na data nyingi. Ni msingi muhimu kabla ya kutumia Absolute au Mixed References.