Question

2. What is mixed reference?​

Answer 1

Answer:

Mixed References in Excel

Excel Mixed References

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 press F4 on the cell two times.

Explanation:

hope it helps you ☺️

Answer 2

Answer:

MIXED REFERENCE IN EXCEL

Mixed Reference in excel is a type of cell reference which is defferent from 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 press F4 on the cell two times.

Explanation:

Mixed Reference are tricky referencing. A dollar sign is used before the row or the column for mixed reference. Excel Mixed Reference locks the column or the row behind which the dollar sign applied . Mixed Reference locks just one of the cells but not both.

....................................................

❤️Hope it's helpful...

...Please mark me as Brainliest dear✅