A key building block in formula writing is the ability to use absolute and relative cell references. Though the term Absolute cell reference sounds too complex and goes over the head, but it is an EXTREMELY IMPORTANT concept for formula construction and usage….. and you MUST KNOW it.
Absolute cell reference in Excel is used when you don’t want the cell reference to change with the formula or function being copied and pasted to other cells.
