Relative and Absolute Cell References in Google Spreadsheets
Channel: Ruchi Sharma Pandey
Date: 2020-09-08

This video explains how relative and absolute cell references work in Google Spreadsheet. The same concepts can be extended to Microsoft Excel as well as it works exactly the same way there.
We start with explaining basic cell references and their behaviour during Cut/Copy-Paste operations and then move on the the usage of the "$" (dollar sign) to fix whole or part of the reference so it doesn't change during Cut/Copy-Paste operations.
We then illustrate the concepts through two simple examples of a running summation and a row-column multiplication table.
The video is made for absolute beginners and concepts are deliberately explained slowly so that anyone can understand it easily