Whats is the difference between relative and absolute referencing on a spreadsheet?
A relative reference occurs when a cell is entered in a formula without using the $ symbol. For example, =A1 It means that if you copy the formula to another cell up & down and sideways all the REFERENCES of the formula will also move a corresponding number of cells up & down and sideways. Example: If you copy a formula 2 rows to the right, then the cell references in the formula will shift 2 cells to the right. If you copy a formula 3 rows down and 1 row left, then the cell references in the formula will shift 3 rows down and 1 row left. An absolute reference occurs when a cell is entered in a formula using the $ symbol. For example: =$A$1 When you copy/move the formula to another cell, Excel would not change the reference, excel will always refer to this specific location, no matter where this formula gets copied or moved. You could also use hybrid references where the column or the row could be defined as absolute or relative. In this case, to prevent Excel from changing the referen
