Home » MCQs » Google Sheets MCQs

Which of the following is an absolute cell reference?

8. Which of the following is an absolute cell reference?

1. B2
2. #B2
3. B:2
4. $B$2

Answer: D) $B$2

Explanation:

$B$2 is an absolute cell reference.