Question

which commands take you to cell referns or cell name​

Answer 1

Answer:

Define a name for a cell or cell range on a worksheet

Select the cell, range of cells, or nonadjacent selections that you want to name.

Click the Name box at the left end of the formula bar. Name box.

Type the name that you want to use to refer to your selection. Names can be up to 255 characters in length.

Press ENTER.

Answer 2

The cell ADDRESS function is categorized under Excel Lookup and Reference functions. It will provide a cell reference (its “address”) by taking the row number and column letter. The cell reference will be provided as a string of text. The function can return an address in a relative or absolute format and can be used to construct a cell reference inside a formula.