FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
How many columns in MS-Excel 2007?
A
16, 384
B
1, 048, 576
C
1, 047, 575
D
16, 345
Explanation: 

Detailed explanation-1: -The number of rows and columns from Excel 2007 onwards is 10, 48, 576 rows and 16, 384 columns.

Detailed explanation-2: -The last column is XFD. Bill Jelen’s answer: There are 16, 384 columns in Excel. This number is 2 raised to the 14th power. There are 1, 048, 576 rows in Excel, which is 2^20.

Detailed explanation-3: -The first 26 columns are A to Z. The 27th column uses another digit and starts that digit at A, hence AA. When all the two-digit headers have been used, another digit is added. In a 26 base system, the value XFD equals 16384.

Detailed explanation-4: -What it means Beginning with Excel 2007, the worksheet size is 1, 048, 576 rows tall by16, 384 columns wide, but Excel 97-2003 is only 65, 536 rows tall by 256 columns wide.

There is 1 question to complete.