DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
256 columns and 65356 rows
|
|
|
256 columns and 65536 rows
|
|
|
256 columns and 63536 rows
|
|
|
256 columns and 65536 rows
|
Detailed explanation-1: -The Microsoft Excel spreadsheet software limits the size of a worksheet size to 65, 536 rows by 256 columns. If your report contains more than 65, 536 rows, it is split into multiple worksheets. The number of worksheets that your report can contain is limited by the physical memory of your computer.
Detailed explanation-2: -Note. 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. The only factor that ultimately limits the number of worksheets your workbook can hold is your computer’s memory.
Detailed explanation-3: -Click File > Info > Check for Issues. Choose Check Compatibility. To check for compatibility automatically from now on, check the Check compatibility when saving this workbook box.