Question

What is relative refercing in Ms excel​

Answer 1

Answer:

By default, a cell reference is a relative reference, which means that the reference is relative to the location of the cell. ... When you copy a formula that contains a relative cell reference, that reference in the formula will change.

Example: =SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the next cell. Situations arise in which the cell reference must remain the same when copied or when using AutoFill..

HOPE IT HELPS YOU

MARK ME AS BRAINLIEST ANSWER

Answer 2

Answer:

Relative cell references are basic cell references that adjust and change when copied or when using AutoFill. Example: =SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the next cell.