Question

write the cell address for the following 1. First row and first column 2.First column and last row. 3. 10th column and 19th row. pls answer quickly​

Answer 1

Answer:

Row function returns the first-row number from the table array. address function takes the row_num & column_value as arguments and returns its absolute reference.  First Cell in UsedRange; Row: 2, Column: 2 Last Cell in UsedRange; Row: 5, Column: 6 First UsedCell in UsedRange. Syntax of “row” function: =row (reference) Example: =row (A1) would return 1 =row  would return 1 =ROW would return 1 index: The Index formula returns a value from the intersection between the row number and the column number in an Array.

Hope this helped you!

Explanation: