Microsoft Excel Question: Download Questions PDF
Excel Limits and Specifications:
Answer:
I need more than 256 columns and/or 65536 Rows.
In Excel 2003, and earlier versions, that's the limit. Excel 2007 has 1,048,576 rows and 16,384 columns.
How many worksheets I can put in a workbook?
It is not a limit per se, but of course there is a practical one which depends on the computer resources.
How many characters can be placed in a cell?
In Excel 97 and above, you can have up to 32K characters in a worksheet cell, but only the first 1000 or so are displayed (the exact number depends on your font and display characteristics). However, you can increase the number of characters displayed if you add line breaks in the cell (press Alt+Enter).
In Excel 2003, and earlier versions, that's the limit. Excel 2007 has 1,048,576 rows and 16,384 columns.
How many worksheets I can put in a workbook?
It is not a limit per se, but of course there is a practical one which depends on the computer resources.
How many characters can be placed in a cell?
In Excel 97 and above, you can have up to 32K characters in a worksheet cell, but only the first 1000 or so are displayed (the exact number depends on your font and display characteristics). However, you can increase the number of characters displayed if you add line breaks in the cell (press Alt+Enter).
Download MS Excel Interview Questions And Answers
PDF