Question

explain what are absolute and relative referencing in excel

Answer 1

Unlike relative references, absolute references do not change when copied or filled. You can use anabsolute reference to keep a row and/or column constant. An absolute reference is designated in a formula by the addition of a dollar sign ($).

Answer 2

All cell references are relative reference.when any formula copied across multiple cells,they change based on the relative position.For example =sum (A1+B1) it will changed in =sum(A2+B2).

Hope it will help you