Question

In how many ways a cell address can be given?​

Answer 1

Explanation:

You can enter cell references in formulas in three ways: Type in the cell or range address. Type in the name of a named cell or range. For information on defining names, see Using Names.

Answer 2

Answer:

The cell ADDRESS function is categorized under Lookup and Reference functions. It will provide a cell reference (it’s “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, and 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])

The formula uses the following arguments:

Row_num (required argument) – It is a numeric value specifying the row number to be used in the cell reference.

Column_num (required argument) – It is a numeric value specifying the column number to be used in the cell reference.

Abs_num (optional argument) – It is a numeric value specifying the type of reference to return:

(No need to mark me as Brainlist, it's just copy paste)...