Question

write the cell address of first row and first column

Answer 1

Answer:

1,A

Explanation:

=ADDRESS(ROW(data),COLUMN(data))

Answer 2

A cell reference, or cell address, is an alphanumeric value used to identify a specific cell in a spreadsheet. Each cell reference contains one or more letters followed by a number. The letter or letters identify the column and the number represents the row.

•••another•••

In a standard spreadsheet, the first column is A, the second column is B, the third column is C, etc.

To get the address of the first cell in a named range, you can use the ADDRESS function together with ROW and COLUMN functions. In the example shown, the formula in G6 is: = ADDRESS ( ROW ( data ) + ROWS ( data ) - 1 , COLUMN ( data ) + COLUMNS (...