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

Question

Which of the following is a valid cell address in excel?

1. 84
2. 3F
3. B5
4. BB
5. F0

Answer

C. B5

Explanation

A cell address writing in excel always follows this pattern: the cell’s column letter first, followed by the cell’s row number. You can see the example of this when you refer to a cell in a formula you type in excel.

For an example of a cell address writing in excel, take a look at the example below.



As you can see, the cell address writing pattern when we refer to a cell in a formula is like that. It is the cell’s column letter first, followed by its row number.

Between the five answer choices in the question, only C and E follow the right pattern. However, the E answer choice number is 0 there. As a row number cannot be 0 in excel (excel row number starts with 1), that means the correct answer for the question is C.

Go back to the Compute Expert's excel quiz page