In dash referencing the relative address of the cell gets adjusted with respect to the current cell.
Answers
Answered by
15
Relative referencing
Explanation:
Relative reference is a cell reference in which formula changes across multiple cells depending upon the relative position of rows and columns.
Example: If you copy the formula =A1+B1 from row 1 to row 2, then formula will become =A2+B2
An absolute reference is a cell reference in which formula remains constant across multiple cells.
Answered by
5
In 'relative referencing', the 'relative address of the cell' gets adjust 'with respect to the current cell'.
Explanation:
- A relative reference in Excel is a cell address without the '$ sign' in the 'row and column coordinates'. When a formula with 'relative cell references' is copied to 'another cell', the reference changes based on a relative 'position of rows and columns'. By default, 'all references in Excel' are relative.
- This means that the 'program not store the actual address', but instead, the 'program stores' the 'number of columns and rows' calculated 'relative to the cell' containing the 'formula'.
To know more
What is relative referencing
https://brainly.in/question/10280545
Defination of relative referencing
https://brainly.in/question/5918738
Similar questions