Question

what are the different types of cell reference​

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.

Answer 2

Answer:

There are three types of cell references:

1) Relative cell reference

2) Absolute cell reference

3) Mixed cell reference

Explanation:

1) Relative cell reference: Relative cell references are basic cell references that adjust and change when copied or when using AutoFill.

2) Absolute cell reference: An absolute cell reference is a cell reference in a spreadsheet application that remains constant even if the shape or size of the spreadsheet is changed, or the reference is copied or moved to another cell or sheet. 

3) Mixed cell reference: Mixed reference in excel is a type of cell reference which is different from the other two absolute and relative, in mixed cell reference we only refer to the column of the cell or the row of the cell.