EDUCATION UGC NET
ICT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
65536
|
|
|
66536
|
|
|
67536
|
|
|
68536
|
Detailed explanation-1: -Excel 2003 supports a maximum of 65, 536 rows per worksheet.
Detailed explanation-2: -65, 536 rows. 256 columns. 255 worksheets in a workbook.
Detailed explanation-3: -It sounds like you have a workbook from before Excel 2007 opened in Excel 2007’s compatibility mode (look in the title bar and see if it says compatibility mode). If so, there are 65, 536 rows instead of 1, 048, 576 in the workbook.
Detailed explanation-4: -Yes, Excel has maximum row limits! According to Microsoft Support (latest version): Excel’s maximum row limit is 1, 048, 576. Columns are limited to 16, 384.
Detailed explanation-5: -From Excel 2007 onwards (2010, 2016, etc) we have exactly 10, 48, 576 rows and 16, 384 columns. But with the Excel 2003 version, we have only 65, 000 rows and 255 columns.