Which of the following is a Valid Cell Range in Excel?
Home >> Excel Tutorials from Compute Expert >> Excel Tips and Trick >> Excel Quiz >> Which of the following is a Valid Cell Range in Excel?
Question
Which of the following is a valid cell range in Excel?- A1;C4
- A1-C4
- A1:C4
- C4;A1
- C4:A1
Answer
C. A1:C4Explanation
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