Question:

Where is the address of the active cell displayed?

Show Hint

Remember: Active cell's address → Name Box, Active cell's contents → Formula Bar.
Updated On: Sep 11, 2025
  • Row heading
  • Status bar
  • Name Box
  • Formula bar
Hide Solution
collegedunia
Verified By Collegedunia

The Correct Option is C

Solution and Explanation

Step 1: Understanding the active cell.
In MS Excel (and other spreadsheets), the active cell is the one where the cursor is currently placed, and any data entered will go into that cell.

Step 2: How Excel shows the active cell's address.
- Row heading only displays row numbers, not the address.
- Status bar shows information like average, sum, or ready/edit mode, not the address.
- Name Box (located on the left side of the formula bar) always displays the address of the currently active cell.
- Formula bar shows the contents (data/formula) of the active cell, not its address.

Step 3: Conclusion.
Hence, the address of the active cell is displayed in the Name Box.

Final Answer: \[ \boxed{\text{Name Box}} \]

Was this answer helpful?
0
0

Questions Asked in CUET exam

View More Questions