Question

what is cell refrence ? mention it's types ​

Answer 1

Explanation:

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 2

$\huge{\underline{\bold{\fbox{\color{red}{Cell\:Reference}}}}}$

• ✏$\sf\large{\orange{Cell \:Reference}}$ means the cell to which another cell refers. For instance, if in B2 you have = B3, cell B2 is referring to cell B3. The cell Reference in this example is B3.✍

• ✏Cell reference is often used when creating Exel worksheet and writing formulas.✍

$\large{\underline{\bold{\fbox{\color{green}{Types\:of\:Cell\:Reference:-}}}}}$

• ✏1️⃣. Relative ✍

• ✏2️⃣. Absolute ✍

• ✏3️⃣. Mixed✍