FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Excel is capable of ____ rows, and ____ Columns.
A
1048576, 16384
B
65536, 296
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -The term Worksheet used in Excel documents is a collection of cells organized in rows and columns. It is the working surface you interact with to enter data. Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information.

Detailed explanation-2: -Microsoft Excel 2007 is limited to: 1, 048, 576 rows. 16, 384 columns.

Detailed explanation-3: -1, 048, 576 Is The Limit. Yes, Excel has maximum row limits! According to Microsoft Support (latest version): Excel’s maximum row limit is 1, 048, 576.

There is 1 question to complete.