Question

In MS Excel, the columns are numbered from A onwards till Z column is reached. After Z Column, the series start with ______ and so on.
1. AA, AB, ...
2. A1, A2...
3. 1A, 2B...
4. 11A, 22B...

Answer 1

Correct Answer - Option 1 : AA, AB, ...

The correct answer is AA, AB, ...

• In MS Excel, the columns are numbered from A onwards till the Z column is reached.
• After Z Column, the series starts with AA, AB, ... and so on. 
• For MS Excel 2010, Row numbers range from 1 to 1048576; in total 1048576 rows.
• Columns range from A to XFD; in total 16384 columns.

Worksheet and workbook specifications and limits:

• Total number of rows and columns on a worksheet - 1,048,576 rows by 16,384 columns
• Column width - 255 characters
• Page breaks - 1,026 horizontal and vertical
• Row height - 409 points