A. 65,536
B. 16,384
C. 1,048,576
D. None of Above
Submitted by: Ali Mallah
Related Mcqs:
- How many rows are in one Microsoft Excel sheet?
A. 65,536
B. 16,384
C. 1,048,576
D. None of AboveSubmitted by: Ali Mallah
- In excel columns are labelled as____________?
A. A, B, C, etc.
B. 1, 2, 3, etc.
C. A1, A2, A3, etc.
D. $A$1, $A$2, etc.Submitted by: Anwar Haleem
- Which shortcut key is used for calculating current sheet in Ms Excel?
A. Ctrl+F9
B. Shift+F9
C. F9
D. F7Submitted by: Imran
- Move to Next Sheet in Ms Excel:
A. Ctrl + Page Down
B. Shift + Page Down
C. Page Down
D. None of theseSubmitted by: FAWAD MATLOOB
- To Open Columns dialog box quickly in Microsoft Word:
A. double click the space between area on ruler
B. double click the right margin in ruler
C. double click on the left margin area of ruler
D. All of above - The minimum number of rows and columns in Microsoft Word document is____________?
A. 1 and 1
B. 2 and 1
C. 1 and 2
D. 2 and 2 - Microsoft Excel 2019 files have a default extension of___________?
A. .Xlsx
B. .Xls
C. .excel
D. .123Submitted by: Wiki
- Actual working area of Computer’s Microsoft Excel is ________ ?
A. Workbook
B. Worksheet
C. Notesheet
D. NotebookSubmitted by: Rashid Mehmood
- In Excel which key is used to open the excel formula window?
A. Shift+F6
B. Shift+F3
C. Alt+Shift+F3
D. Alt+Shift+F6Submitted by: Muhammad Danish
- Shortcut to quit Microsoft Word, Powerpoint, Access, Excel etc is ______________.
A. Alt + F4
B. Ctrl + W
C. Shift + F4
D. Alt + WSubmitted by: Muhammad Danish
1 Comment
There are 220=1,048,576 rows, and 214=16,384 columns in an an Excel worksheet, at least since Excel 2007.
To find out how many rows, you can open an empty worksheet, and press CTRL-Down-Arrow key combination on your keyboard. The cursor will move all the way to the bottom row of the sheet. Look for the row number on the left.
To find out how many columns, you can press CTRL-Right-Arrow key combination in an empty worksheet, and you will find yourself at column XFD. So how many columns is that?
There are 26 columns labeled A through Z, and then there are 262=676 columns labeled AA through AZ. Then start the columns with 3-letter names. Treat AAA like 000 in base 26 arithmetic. Treat A as the 0 digit, and Z as the 25 digit in base 26 numerals. So X is the 23 digit, F is the 5 digit, and D is the 3 digit, and XFD is the base-26 for 23×262+5×26+3×1=15,681 . So the three-letter column names run from 0 to 15,681, so there are 15,682 of them.
So altogether there are 26 + 676 + 15,682 = 16,384 columns.
Excel 2003 only had 65,536 (what power of 2 is that?) rows, and 256 columns.