Correct Answer:
B. 1,048,576
The correct answer is 1,048,576. This represents the maximum number of rows available in a Microsoft Excel worksheet for versions from Excel 2007 onwards. Understanding these limits is fundamental for effective data management in spreadsheets.
- 65,536 was the row limit for older versions of Excel, specifically Excel 2003 and earlier, making it a common distractor for those familiar with older software.
- 104,857 and 16,384 are incorrect values and do not correspond to any standard Excel row limits.
Modern Excel versions significantly expanded capacity to handle more extensive datasets.