Question

2 What is Cell Reference? Mention its types.​

Answer 1

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.

There are two types of cell references: relative and absolute.

Answer 2

Answer:

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. In one or several formulas, you can use a cell reference to refer to: ... Data contained in different areas of a worksheet.

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.

hope it helps u..!!