Question

which box shows the address of an active cell

Answer 1

Name Box Shows address of active cell

Answer 2

In Excel spreadsheet, we  can find the address of the active cell by doing the following.

EXPLANATION:  

Every cell in the sheet has its own address. We can find the address by typing = ADDRESS(ROW(), COLUMN()) in the active cell and press the “enter key”. And then we can find the address moves to the formula bar and displays the required address in the cell.