DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
16, 384
|
|
|
1, 048, 576
|
|
|
1, 047, 575
|
|
|
16, 345
|
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.