MCQ
Q.
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
Correct Answer: A
The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.