Question

What is a cell reference? Explain all three types of cell references with examples

Answer 1

A cell reference is a term for a cell or a group of cells on a worksheet that may be used in a formula to instruct Microsoft Office Excel where to find the values or data for the computation.

• ABSOLUTE CELL REFERENCE:

1. A dollar sign precedes each letter or number in a reference, for example, $A$2.
2. When a dollar sign precedes the column and row identities, the column and row become absolute or locked, meaning the cell reference remains constant even if copied or dragged to another cell.

• RELATIVE CELL REFERENCE:

1. In a row or column, relative cell references do not include dollar signs, for example, B2.
2. The relative cell reference type in Excel changes when a formula is copied or dragged to another cell; cell referencing in Excel is relative by default; it is the most commonly used cell reference in the formula.

• MIXED CELL REFERENCE:

1. Dollar signs are associated with either the letter or the number in a reference cell.
2. $A9 or D$8 are two examples.
3. The coordinates are a mix of relative and absolute.

Answer 2

read full plz

actually I also have same question so can't help you but only so much little