Computer Science, asked by rohitOdisha, 11 months ago

In dash referencing the relative address of the cell gets adjusted with respect to the current cell.​

Answers

Answered by suskumari135
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 smartbrainz
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