FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
How many cells are there on a single worksheet?
A
1, 718 cells
B
17, 180 cells
C
171, 799 cells
D
17, 179, 869, 184 cells
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: -From Excel 2007 onwards (2010, 2016, etc) we have exactly 10, 48, 576 rows and 16, 384 columns.

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

Detailed explanation-4: -A cell can contain 32, 767 number of characters.

There is 1 question to complete.