define mixed reference with an example
Answers
Answered by
3
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.
Answered by
0
Answer:
It is the address of a cell absolute column and a relative row or a absolute row and a relative column is known as Mixed reference.
Explanation:
In a simple definition!
Similar questions