What do you know about Mixed Reference? Explain with the help of an example.
Answers
Answered by
1
Answer:
Mixed reference in excel is a type of cell reference which is different from the other two absolute and relative, in mixed cell reference we only refer to the column of the cell or the row of the cell, for example in cell A1 if we want to refer to only A column the mixed reference would be $A1, to do this we need to
Answered by
0
Mixed reference in excel is a type of cell reference which is different from the other two absolute and relative, in mixed cell reference we only refer to the column of the cell or the row of the cell, for example in cell A1 if we want to refer to only A column the mixed reference would be $A1, to do this we need to . Mixed reference Excel definition: A mixed reference is made up of both an absolute reference and relative reference. This means that part of the reference is fixed, either the row or the column, and the other part is relative.
Similar questions