DATABASE FUNDAMENTALS
WORKBOOK THEMES
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The number of worksheets that a workbook can contain is ____
|
Unlimited
|
|
9, 999, 999
|
|
Limited by Computer Memory
|
|
Limited by the Number You Add to it.
|
Explanation:
Detailed explanation-1: -Although you’re limited to 255 sheets in a new workbook, Excel doesn’t limit how many worksheets you can add after you’ve created a workbook.
Detailed explanation-2: -A workbook must contain at least a visible worksheet. By default, a new Excel workbook will contain one worksheets. You can switch between worksheets by clicking on the worksheet’s tab at the bottom of the Excel window.
Detailed explanation-3: -Microsoft says that the maximum size of a single Excel spreadsheet is 1, 048, 576 rows by 16, 384 columns.
Detailed explanation-4: -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.
There is 1 question to complete.