what is cell referencing?what are the various types of cell referencing ?
Answers
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. Absolute references, on the other hand, remain constant no matter where they are copied.
Explanation:
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. Absolute references, on the other hand, remain constant no matter where they are copied.
Explanation:
hope it helps... have a great day