John is working in Excel and notices that his rows are numbering past 2000. What would be the best action in this situation?
A) Break the sheet into different workbooks.
B) Delete the data even if it is necessary.
C) Begin using a database instead.
D) Just keep adding data, Excel is limitless.

Question

Quizplus · Accepted Answer

Excel has a limit on the number of rows and columns it can handle (1,048,576 rows and 16,384 columns in a worksheet, as of the latest versions). When working with very large datasets, it's more efficient and practical to use a database, as databases are designed to handle, manipulate, and analyze large volumes of data more effectively than spreadsheet software.

John Is Working in Excel and Notices That His Rows