Learning Microsoft Excel
Question 6 - Answer
Which of these are valid cell
addresses?
The naming convention for a cell reference is the alphabetic column letter
position followed by the row number. You may use either lower or upper case
letters when referencing a column.
- G3000 is a valid cell address - - a letter (G) followed by
a number (3000)
- DH30 is a valid cell address - - two letters (DH) followed
by a number (30)
- 20AD is not a valid cell address. Letters (columns)
come before numbers (rows).
- b20 is a valid cell address - - a letter (b) followed by a
number (20).
- Ab6000 is a valid cell address.
- 550 is not a valid cell address. It is missing the
column designation.