define mixed reference with an example
Home
/
Computer Science
/
define mixed reference with an example
define mixed reference with an example
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
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:
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!