Question

what gives the address of the selected cell​

Answer 1

Answer:

Then you can see the address of the current selected cell is displaying in the cell immediately. Note: If you go to select a different cell, the address would not change automatically.

Answer 2

Answer:

=ADDRESS(ROW(),COLUMN())

Then you can see the address of the current selected cell is displaying in the cell immediately. Note: If you go to select a different cell, the address would not change automatically.