The symbol used to lock the cell reference, in MS - Excel is :
A#
B&
C$
D/
Answer:
C. $
Read Explanation:
- The symbol used to lock a cell reference in MS - Excel is :
$ ( Dollar sign )
- When you precede a column letter or row number with a dollar sign ( $ ) , it locks the reference, making it absolute. This means that the reference will not change when you copy or move the formula to another cell.
- Using the dollar sign ensures that the reference remains fixed, even when the formula is copied or moved.