Correct option is C
In MS Excel 2010, the maximum number of rows in a worksheet is 1,048,576. This allows users to work with a vast amount of data within a single worksheet, making it possible to handle large datasets and perform complex calculations.
Important Key Points:
1. Row Limit: Excel 2010 supports up to 1,048,576 rows in a single worksheet, providing ample space for large datasets.
2. Column Limit: In addition to rows, Excel 2010 supports 16,384 columns (labeled from A to XFD).
Knowledge Booster:
· Excel 2003 vs. Excel 2010: Earlier versions of Excel (like Excel 2003) had a lower row limit of 65,536, but newer versions, including Excel 2010, greatly increased the row limit to accommodate more data.
· Performance Considerations: While Excel 2010 supports such a large number of rows, the performance can be impacted depending on the complexity of the data and calculations, especially when working with millions of rows.