Question

What is the address of first cell and last cell of MS Excel 2010?​

Answer 1

Answer:

To get the address of the first cell in a named range, you can use the ADDRESS function together with the ROW and COLUMN functions.

How this formula works

The ADDRESS function builds an address based on a row and column number.

Working from the inside out, the ROW function returns an array of absolute* row numbers for a given range, and the COLUMN function returns an array of column numbers.

The ADDRESS function then assembles and returns an array of addresses. When entered in a single cell, just the item from the array is displayed, which is the address corresponding to the first cell in a range.

* By absolute, I mean numbers that track to the entire worksheet, not numbers relative to the range itself.

Explanation:

please

Answer 2

Answer:

lolistics haaaaaaaaaaaaaaaaa