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
7311
Which pointer shape lets you select multiple cells?
Answer:
Doctor’s symbol (big plus)
The big plus cursor is for cell range selection.
7312
It’s fine to let text spill into adjacent cells when:
Answer:
No data will be added to adjacent cells
If adjacent cells are empty, text will display in full across columns.
7313
How do you convert a column of data to a row?
Answer:
Edit >> Paste Special >> Transpose
Paste Special with the Transpose option will flip columns to rows.
7314
Which is NOT a choice in Excel’s Paste Special dialog?
Answer:
SQRT
Add, subtract, and divide are options, but “SQRT” is not.
7315
What does Ctrl + X do after selecting cells in Excel?
Answer:
Marks the region for cutting (can paste)
Ctrl+X marks cells to cut so they can be pasted elsewhere.
7316
Which Excel interface element cannot be turned off?
Answer:
None of above
All these elements can be shown or hidden as needed.
7317
How do you make gridlines appear or disappear in Excel?
Answer:
Both of above
Gridlines can be controlled via Options or specialized toolbars.
7318
Where is calculation mode (auto/manual) changed in Excel?
Answer:
Tools >> Options >> Calculation
Calculation settings are changed under Tools > Options > Calculation tab.
7319
If you want to autofill Nepali months (Baishakh, Jestha, Aashadh, …), which feature do you use?
Answer:
Custom List
Create a custom list for non-default fill series to use with autofill drag.
7320
If Auto Calculate is turned off, how do you manually update formula results?
Answer:
F9
F9 recalculates all formulas in the worksheet.