Which of the following is a Valid Cell Range in Excel?

Question

Which of the following is a valid cell range in Excel?

1. A1;C4
2. A1-C4
3. A1:C4
4. C4;A1
5. C4:A1

Answer

C. A1:C4

Explanation

The writing of a cell range in Excel always starts with the cell address of the cell on the top left of the cell range first, followed by a colon, and then followed by the cell address of the cell on the bottom right of the cell range.

The only answer choice that follows this writing pattern is C. Thus, the correct answer here is that answer choice.

Go back to the Compute Expert's excel quiz page