Which of the following refers to Column B, Row 2 on the worksheet called Sheet2?
A) Sheet2$B2
B) Sheet2!B2
C) Sheet2&B2
D) Sheet2#B2

Name: Which of the following refers to Column B, Row 2 on the worksheet called Sheet2? A) Sheet2$B2 B) Sheet2!B2 C) Sheet2&B2 D) Sheet2#B2
Brand: Quizplus
Rating: 4.8 (27 reviews)

Question

Quizplus · Accepted Answer

The correct notation to refer to a cell in Excel is by using an exclamation mark (!) between the sheet name and the cell reference. Therefore, "Sheet2!B2" correctly refers to Column B, Row 2 on the worksheet called Sheet2.

Which of the Following Refers to Column B, Row 2