Question

explain how to write a cell address with an example.
in excel worksheet

Answer 1

Answer:

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.

As a financial analyst, cell ADDRESS can be used to convert a column number to a letter, or vice versa. We can use the function to address the first cell or last cell in a range.

Formula

=ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])

Answer 2

Answer:

Cell address/reference :-

A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet.

To make a cell reference on the same sheet, this is what you need to do:

1. Click the cell in which you want to enter the formula.

2. Type the equal sign (=).

3. Do one of the following:

   (i). Type the reference directly in the cell or in the formula bar, or

  (ii). Click the cell you want to refer to.

4. Type the rest of the formula and press the Enter key to complete it.