LIVE Course for free

Rated by 1 million+ students
Get app now
0 votes
33 views
in General by (54.3k points)
closed by
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...

1 Answer

0 votes
by (30.0k points)
selected by
 
Best answer
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 

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...