Question

what is cell reference? mention it's types

Answer 1

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.

Answer 2

☆ Answer ☆

Cell reference is also known as cell address. It identifies the location of a cell in a group of cell in the worksheet. These cell addresses are used in formula and functions.

Types of Cell Reference

Cell References are of three types :-

1. Relative Cell Reference

2. Absolute Cell Reference

3. Mixed Cell Reference

1. Relative Cell Reference :-

Relative cell reference is a default cell reference . If you move or copy a formula to another cell the cell referred to in the formula will change accordingly.

2. Absolute Cell Reference :-

In absolute cell reference if you move or copy the formula to another cell the cell referred to in the formula will not change. Excel does not adjust the absolute cell reference.

3. Mixed Cell Reference :-

Mixed cell reference consists of both relative and absolute cell reference. Excel adjust the relative path of the reference wild absolute path is not adjusted. In a mixed cell reference only the row or only the column remain fixed in a formula .