Question

Explain mixed reference with the help of a example ?
​

Answer 1

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 =A$1 // row locked =$A$1:A2 // first cell locked