Question

Explain the concept of cell referencing alongwith its various types.

Answer 1

Answer -

____________________________________

• There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant, no matter where they are copied.

____________________________________

→ Hope it will help you ❣️❣️

Answer 2

Answer:

A cell reference in Excel refers to the value of a different cell or cell range on the current worksheet or a different worksheet within the spreadsheet. A cell reference can be used as a variable in a formula.

Answer by keshav kumar Singh