Question

It displays the address of the selected cell

Answer 1

While using the Microsoft Excel, you can easily get the location of currently selected cell in the Name Box which lists on the left of the Formula Bar. But if the cell is named, you can't examine its location based on the displaying on the Name Box.

Answer 2

Explanation:

Formula bar displays the content of the active cell in Excel.

An active cell refers to a cell in Excel spreadsheet that is currently selected by clicking mouse pointer or keyboard keys. Remember only one cell can be an active cell at a time. An active cell is bounded by a heavy border around it.

A toolbar at the top of the Microsoft Excel spreadsheet window that you can use to enter or copy an existing formula in to cells or charts. It is labeled with function symbol (fx). By clicking the Formula Bar, or when you type an equal (=) symbol in a cell, the Formula Bar will activate.

Display or Hide the Formula Bar in Excel. Open your spreadsheet and click on the File menu. Next, click on Excel Options and move to the Advanced tab. Scroll to the Display section.

Active Cell. An active cell refers to the currently selected cell in a spreadsheet. ... Whenever you click on a specific cell within a spreadsheet, it becomes the active cell. Once a cell is selected, you can enter values or a function into the cell.