Question

The cell address of column B and 5th row is​

Answer 1

Answer:

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

The formula uses the following arguments:

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

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

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