Question

what is relative reference. absolute reference and mixed reerncr​

Answer 1

Answer:

Relative reference

When we drag any formula in any row or column in a y direction , the formula gets copied in the new cell with the relative reference.All most all application use relative reference by default.

Mixed Referencing

In mixed Referencing the $ sign is used before row number or column name to make it constant.

Absolute Referencing

In absolute Referencing, $ symbol is used before the column name as well as row number to make it constant in any formula.

Explanation:

.

Mark my answer as brainalist..

Answer 2

Explanation:

1) Relative referencing : In relative referencing, both column part and row part are not fixed .

2) Absolute referencing : In absolute referencing, both column part and row part are fixed.

3) Mixed referencing : In mixed referencing,either column part or row part is fixed.