Correct option is B
In MS Excel (starting from Excel 2007 onwards), the maximum number of rows available in a single worksheet is 1,048,576. Earlier versions of Excel (such as Excel 2003) had a maximum of 65,536 rows, but the limit was increased significantly in later versions to support larger data sets.
Important Key Points:
1. Excel Row Limit - 1,048,576 rows and 16,384 columns are the maximum in Excel versions 2007 and onwards.
2. Sheet Specifications - These increased limits make Excel more powerful for data analysis, allowing users to store and analyze significantly larger datasets.
Knowledge Booster:
• 65,534: This number is incorrect. In Excel 2003, the limit was 65,536 rows, not 65,534.
• 10,68,576: This number is not a valid specification for Excel; the actual number of rows is 1,048,576.
• Unlimited: The number of rows is not unlimited. It is fixed at 1,048,576 in Excel 2007 and newer versions.