A. 65,536
B. 16,384
C. 1,048,576
D. None of Above
Submitted by: Ali Mallah
- Computer Mcqs
Computer Fundamental MCQs, Computer MCQs , MS Office, MS Excel, MS Word, MCQ on Internet, MCQ Quiz KPPSc MCQs, MCQ of Computer Science, NTS GAT, Computer has become most demand able thing in any work. Almost all departments have computer need. And it every important to know the basic Knowledge of computer. If you want to get job or admission related to computer, you must prepare online for computer science MCQ’S questions and answers. Most of the test conductors like FPSC, NTS, KPPSC, PPSC and others, are adding computer knowledge MCQs in their test patron. Having a good command on the computer is very necessary. Here are some MCQs related to the Computer from basic to advance will help our readers to secure high marks in the computer portion of the test.
COMPUTER MCQS 1. Microsoft Word Mcqs 2. Microsoft PowerPoint Mcqs 3. Microsoft Excel Mcqs COMPUTER ONLINE QUIZ TEST - Microsoft Excel Mcqs
Microsoft Excel Mcqs for Preparation. Ms Excel Mcqs are very important Mcqs in Computer section.its very important to know the basic Knowledge of computer.Most of the test conductors like FPSC, NTS, KPPSC, PPSC SPSC and others, are adding computer knowledge MCQs in their test patron.
IF YOU THINK THAT ABOVE POSTED MCQ IS WRONG.
PLEASE COMMENT BELOW WITH CORRECT ANSWER AND ITS DETAIL EXPLANATION.
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.