Question

Acces the advantages of
relative
mixed and absolut references
cells in excell 2013?​

Answer 1

Explanation:

Relative reference : Excel calculate a cell's location with respect to the location of the formula containing cell. The benefit of relative referencing is that your formula will automatically change if you need to make several copies of the same formula (for example, through auto fill).

Mixed reference : Mixed references can be used to set up formulas that can be copied across rows or columns without the need for manual editing. In some cases (3rd example above) they can be used to create a reference that will expand when copied.

Absolute reference : Absolute cell references are useful when you don't want the cell reference to change as you copy formulas. This could be the case when you have a fixed value that you need to use in the formula (such as tax rate, commission rate, number of months, etc.)