DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How many columms are there in an Excel 2003 document
|
|
65536
|
|
|
256
|
|
|
1048576
|
|
|
16384
|
Explanation:
Detailed explanation-1: -A workbook automatically shows in the workspace when you open Microsoft Excel 2003 . Each workbook contains three worksheets. A worksheet is a grid of cells consisting of 65, 536 rows by 256 columns.
Detailed explanation-2: -xls file, such as in Excel 2003 or earlier, the last column is named IV. Its number is 256.
Detailed explanation-3: -In Excel 97-2003, worksheet size of 65, 536 rows tall by 256 columns wide.
Detailed explanation-4: -From Excel 2007 onwards (2010, 2016, etc) we have exactly 10, 48, 576 rows and 16, 384 columns. But with the Excel 2003 version, we have only 65, 000 rows and 255 columns.
There is 1 question to complete.