Q. What is the purpose of the OFFSET function in Excel?

A
Sorts a range
B
Returns a reference offset from a starting point
C
Counts cells
D
Merges cells
Solution:

OFFSET() returns a reference to a range that is offset from a starting cell or range by a specified number of rows and columns.

Entri PDF Icon

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.

Entri Contact Image

Get Expert Advice for Free: Register for Your Free Consultation Now!