DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
65535
|
|
|
65536
|
|
|
65636
|
|
|
66535
|
|
|
66636
|
Detailed explanation-1: -65536 is the maximum number of spreadsheet rows supported by Excel 97, Excel 2000, Excel 2002 and Excel 2003. Text files that are larger than 65536 rows cannot be imported to these versions of Excel. (Excel 2007, 2010 and 2013 support 1, 048, 576 rows (220)).
Detailed explanation-2: -65, 536 rows. 256 columns. 255 worksheets in a workbook.
Detailed explanation-3: -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-4: -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.