Question

3 What is cell Reference ?Explain the different types of cell references.


do it fast i give brlint ​

Answer 1

$\huge\color{red}\boxed{\colorbox{black}{♡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 on other worksheets in the same workbook.

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 you

Answer 2

Answer:

A cell reference refers to cell or a range of cell on a worksheet. and cAn be used in a formula so that Microsoft excel can found the value or data that you want that formula . PLEASE. MARK ME AS BRAINLIEST