Question

Which component of the MS-Excel window displays the currently selected cell address?

• A. Title Bar
• B. Name Box
• C. Formula Bar
• D. Status Bar

Hint:

Remember the Excel interface:
• Name Box $\rightarrow$ Cell Address.
• Formula Bar $\rightarrow$ Cell Contents/Formula.
• Title Bar $\rightarrow$ Workbook Name.
• Status Bar $\rightarrow$ Worksheet Status.

Answer 1

The Correct Option is B

Concept: The Name Box in Microsoft Excel displays the address (reference) of the currently active cell. It is located to the left of the Formula Bar and helps users quickly identify or navigate to any cell in the worksheet. For example:
• If cell A1 is selected, the Name Box displays A1.
• If cell C5 is selected, the Name Box displays C5.

Step 1: Understand the purpose of the Name Box.
The Name Box is used to:
• Display the address of the active cell.
• Jump directly to a specified cell by typing its reference.
• Display names of named ranges. Thus, \[ \boxed{\text{Name Box } \rightarrow \text{ Displays the active cell address}} \]

Step 2: Differentiate the Excel components.

• Title Bar -- Displays the workbook name and Excel application.
• Name Box -- Displays the currently selected cell address. (Correct)
• Formula Bar -- Displays or edits the contents/formula of the active cell.
• Status Bar -- Shows worksheet status and quick calculations such as Sum, Average and Count.

Step 3: Example.
Suppose cell D8 is selected.
• Name Box shows: D8
• Formula Bar shows: The value or formula stored in cell D8. This clearly distinguishes the function of the Name Box from the Formula Bar.

Step 4: Final conclusion.
Therefore, the component that displays the currently selected cell address is the: \[ \boxed{\text{Name Box}} \]