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
7011
What command converts columns to rows?
Answer:
Edit » Paste Special » Transpose
The Transpose option in Paste Special is used for this.
7012
Which is NOT an available option in the Paste Special dialog?
Answer:
SORT
Paste Special does not provide "SORT".
7013
What happens when you press Ctrl + X after selecting cells?
Answer:
The contents are removed and stored on the clipboard
Ctrl + X cuts and places the content on the clipboard.
7014
Which Excel screen component can NOT be turned off?
Answer:
None of these
All these can be shown or hidden in Excel.
7015
How do you show or hide gridlines in Excel?
Answer:
Tools >> Options >> View tab: check/uncheck Gridline
The gridline display setting is in Options > View.
7016
Where can you change calculation mode in Excel?
Answer:
Tools >> Options >> Calculation and mark the appropriate radio button
Calculation options are found in the Options dialog under Calculation.
7017
To customize AutoFill (e.g., fill Baishakh, Jestha, ...), set up a:
Answer:
Custom List
Custom Lists create custom fill sequences for AutoFill.
7018
How can you update formula cell values if Auto Calculate is off?
Answer:
F9
Pressing F9 recalculates in Manual Calculation mode.
7019
In a mail merge operation with Excel and Word, Word is usually:
Answer:
Client
Word serves as the main (client) document and Excel as the data (source).
7020
Which is NOT a correct method to edit cell content?
Answer:
Press the Alt key
Alt is not used for editing cell contents.