Question

Define cell referencing and describe different types of cell referencing with example.​

Answer 1

Answer:

There are two types of cell references: relative and absolute. ... 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.

Explanation:

please like

Answer 2

A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.There are two types of cell references: relative and absolute. ... 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.