Question

Different between mixed referencing and absolute referencing by giving suitable examples

Answer 1

Mixed referencing :the row and column reference s don't change when we copy the formula to another cell. Eg & a&1

Absolute referencing :the row and the column reference s don't change when we copy the formula to another cell. Eg:&a1..
Hope it helps you...

Answer 2

Explanation:

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

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