Relative vs Absolute Cell References
Cell references When creating formulas, we use cell references rather than actual values to show Excel which cells to use in the calculation. By referencing which cell to use in a formula. when the value of the cell changes, the result of the formula updates automatically. By default a cell reference is relative, which allows…