Question

explain Mixed Referencing​

Answer 1

$\huge\mathfrak\purple{Answer}$

An mixed reference in Excel is a reference where part of the reference is absolute and part is relative. For example, the following references have both relative and absolute components: =$A1 // column locked =A$1 // row locked =$A$1:A2 // first cell locked.

Answer 2

Answer:

An mixed reference in Excel is a reference where part of the reference is absolute and part is relative. For example, the following references have both relative and absolute components: =A1 // column locked =AA1//columnlocked=A1 // row locked =AA1:A2 // first cell locked.