Define Cell Referencing? What are the 3 types of Cell Referencing?
EXPLAIN EACH BRIEFLY.
Answers
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.
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.
Now there are three kinds of cell references that you can use in Excel:
1)Relative Cell References-: It does not contain dollar signs in a row or column, e.g., A2. Relative cell reference type in excel changes when a formula is copied or dragged to another cell; in Excel, cell referencing is relative by default; it is the most commonly used cell reference in the formula.
2)Absolute Cell References -: Absolute Cell Reference contains dollar signs attached to each letter or number in a reference, e.g., $B$4, Here if we mention a dollar sign before the column and row identifiers, it makes absolute or locks both the column and the row, i.e., where Cell reference remains constant even if it copied or dragged to another cell.
3)Mixed Cell References -: It contains dollar signs attached to either the letter or the number in a reference. E.g., $B2 or B$4. It is a combination of relative and absolute references.