In Excel, Columns Are Labelled as …

Question

In excel, columns are labelled as …

1. Letters (A, B, C, …)
2. Numbers (1, 2, 3, …)
3. Rows
4. Letters and numbers (A1, B1, A2, …)
5. None of the above

Answer

A. Letters (A, B, C, …)

Explanation

In excel, columns are labelled as letters (A, B, C, …) while rows are labelled as numbers (1, 2, 3, …), as you can see in the screenshot below.



When we refer to a cell in an excel formula, the cell reference has the cell’s column letter and row number.



In the first excel version until excel 2003, columns are labelled with letter A until VI (256 columns). After that, from excel 2007 onwards, columns are labelled with letter A until XFD (16,384 columns).

Go back to the Compute Expert's excel quiz page