How to use Absolute and Relative references in Excel | Information and Communication Technology

#absolute #relative #references #msexceltipsandtricks
Assalamualaikum,
Today, we're going to revisit the topic of cell referencing, which comes in two forms: relative and absolute referencing. To recap, relative referencing occurs when you copy a formula to other cells, and the references in the formula adjust accordingly. For example, if you enter the formula `=B2+B3` in cell B5, copying this formula down will change the references to `=B3+B4`, and so on. This automatic adjustment is known as relative referencing.
In contrast, absolute referencing keeps the cell references constant, even when copied to other cells. This is done using a dollar sign (`$`). For example, if you use `$B$2` in a formula, copying it down will still refer to B2.
I'll demonstrate this in Excel. First, I'll show how relative referencing works by creating a simple multiplication table. By copying the formula `=A2*B2` down the column, you'll see the cell references change accordingly. Next, I'll show how to use absolute referencing by adding dollar signs, ensuring the references stay constant.
Let's apply this to a practical example with a table of account balances and zakat deductions. We'll compute the zakat by multiplying the account balance by 2.5%. Using relative referencing for the balance and absolute referencing for the percentage ensures accurate calculations as we copy the formula down the column.
Lastly, we'll calculate the remaining balance by subtracting the zakat from the account balance, ensuring the references adjust correctly.
I hope this clarifies the difference between relative and absolute referencing. Practice this in Excel, and if you have any questions, feel free to ask. If you found this video helpful, please subscribe to my channel and share it with friends and family. Take care, and Allah Hafiz!
🏆Don't forget to like, share, and subscribe for more tutorials. Happy learning! 🎉
_______________________________________________________
Happy learning! 💻🎓🌟
🙂 Was this video lecture helpful??
share your thoughts and feedback in comments.
______________________________________________________
watch more videos:
Database | DBMS |Database Management Systems | IGCSE | AS Information Technology
• Database | DBMS |Datab...
Chapter 20. Spreadsheets
• Chapter 20. Spreadsheets
Watch solved papers
Full November 2023 /22 Solved paper | O Level | IGCSE Computer Science
• Full IGCSE (0478) | O...
Full 2023 Specimen Paper 1A Solution | O Level (2210) IGCSE (0478) Computer Systems for 2023
• Full 2023 Specimen Pap...
Full 2023 Specimen Paper 1B Solution | O Level (2210) IGCSE (0478) Computer Systems for 2023
• Full 2023 Specimen Pap...
Full 2023 November 2023/12 Solution | O Level (2210) IGCSE (0478) Computer Systems Solved
• Full IGCSE (0478) |O ...
🎥MS Excel shorts playlist
🔗 • Mastering MS Excel: Un...
Watch more videos for O Level, IGCSE and A Levels Computer Science
Playlist Paper 1
🔗 • Computer Science Paper 1
Playlist Paper 2
🔗 • Computer Science Paper 2
_________________________________________
Follow me
Facebook: / learncswithsy
Facebook Community: / learncswithsy
For more information contact
email: [e-mail]
#digitalmark3ting #asmaakhlaqa
Managed by: Digitalmark3ting.com
[e-mail]
[phone]
ExcelTutorial, CellReferencing, ExcelFormulas, RelativeReferencing, AbsoluteReferencing, LearnExcel, ExcelTips, SpreadsheetTutorial, ExcelBeginners,ExcelFunctions, ExcelShortcuts, ExcelSkills, ExcelForBeginners, ExcelBasics, MicrosoftExcel, ExcelHacks, Productivity, OfficeSkills, ExcelExamples, ZakatCalculation