Question

wahat are the difference between relative and absolute references

Answer 1

The key difference between relative and absolute cells is that relative cell references move when you copy them, but absolute references do not. ... So a relative cell reference might look like =A1+A2 but an absolute reference might look like =$A$1+$A$2.............Unlike relative references, absolute references do not change when copied or filled. You can use an absolute reference to keep a row and/or column constant. An absolute reference is designated in a formula by the addition of a dollar sign ($). It can precede the column reference, the row reference, or both.