Question

What function returns a reference to a cell (or cell range) that is a specified number of row and columns from a base cell?

Answer 1

The offset function

Explanation:

In Microsoft Excel, the offset function or formula returns reference to a particular cell.

The syntax is:

= OFFSET(reference, rows, cols)

Where:

reference = the base cell

rows and cols are the direction to move

For instance:

OFFSET(A1, 3, 1) will return cell B4

Because:

3 will shift down the reference from A1 to A4

1 will shift right the reference from A4 to B4