Computer Science/IT MCQs
Topic Notes: Computer Science/IT
MCQs and preparation resources for competitive exams, covering important concepts, past papers, and detailed explanations.
Plato
- Biography: Ancient Greek philosopher (427–347 BCE), student of Socrates and teacher of Aristotle, founder of the Academy in Athens.
- Important Ideas:
- Theory of Forms
- Philosopher-King
- Ideal State
7111
Which setting should you check to ensure printing occurs correctly on letterhead paper?
Answer:
Margin
Margins must often be adjusted when using letterhead.
7112
To make a bar chart, which menu should you use?
Answer:
Insert, Chart
Charts are added via the Insert menu.
7113
What is the maximum number of worksheets allowed in a workbook?
Answer:
None of the above
The number of worksheets is only limited by system memory, not to a fixed number.
7114
Which of these is NOT an MS-Excel term?
Answer:
Document
Excel uses "workbook" and "worksheet," not "document."
7115
What programming language is used to write macros in Excel?
Answer:
Visual Basic
Excel macros use VBA (Visual Basic for Applications).
7116
If you want to reference cell A10 on sheet3 while on sheet1, which is correct?
Answer:
sheet3!A10
The syntax is SheetName!CellAddress.
7117
Where does Excel show the current cell address?
Answer:
Name Box
The Name Box displays the address (e.g., A1) of the active cell.
7118
In Excel formulas, which symbol is used to “lock” columns or rows in a cell reference?
Answer:
$
The dollar sign is used for absolute references, fixing columns or rows.
7119
Which keyboard shortcut is used to select an entire column?
Answer:
Ctrl+Space Bar
Pressing Ctrl + Spacebar highlights the whole column.
7120
What is the function of COUNTA() in Excel?
Answer:
Counts non-empty cells
COUNTA counts all non-empty cells in a range.