USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The total number of lines in Ms. Excel____
|
|
65535
|
|
|
65536
|
|
|
65636
|
|
|
66535
|
|
|
66636
|
Explanation:
Detailed explanation-1: -In the modern versions of Excel there are 1, 048, 576 rows. In older versions of Excel (2003 and prior) there were 65, 536 rows.
Detailed explanation-2: -65, 536 rows. 256 columns. 255 worksheets in a workbook.
Detailed explanation-3: -1, 048, 576 Is The Limit. 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.
There is 1 question to complete.