Question

How many types of cell references are there in MS excel 2010

Answer 1

There are two types of cell references: relative and absolute.

Answer 2

Answer:

The correct answer to the given question is:

There are three types of cell references in Excel, they are:

Relative, Absolute, and Mixed

Explanation:

Most formulas you create contain cell or range references. These links allow formulas to act dynamically on the data contained in that cell or range.

There are three types of cell references you can use in Excel 2010 formulas: relative, absolute, and mixed. If you use the correct cell reference type in your formula, the cell reference type will work properly when copied to another location on the worksheet. Formulas and functions need to be understood because they are most useful when using links.

Excel is dynamic with regards to cell addresses. If you have a cell with a formula that references an address in another cell, and you copy the formula from the first cell to another cell, Excel updates the cell reference within the formula.

#SPJ2