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
361
To customize AutoFill (e.g., fill Baishakh, Jestha, ...), set up a:
Answer:
Custom List
Custom Lists create custom fill sequences for AutoFill.
362
How can you update formula cell values if Auto Calculate is off?
Answer:
F9
Pressing F9 recalculates in Manual Calculation mode.
363
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).
364
Which is NOT a correct method to edit cell content?
Answer:
Press the Alt key
Alt is not used for editing cell contents.
365
Which can NOT be a sheet in a workbook?
Answer:
Data sheet
"Data sheet" is not a default sheet type. Worksheets, chart sheets, and module sheets (for macros) are valid.
366
The Name box to the left of the formula bar:
Answer:
Shows the name or reference of the current cell or selected range
The Name box displays the reference or range you are working with.
367
Tab scroll buttons are placed on the Excel screen:
Answer:
Towards the bottom left corner
Tab scroll buttons for sheet navigation are lower-left.
368
Which tool joins cells and centers content?
Answer:
Click Merge and Center tool on formatting toolbar
Merge and Center both joins and centers selected cells’ content.
369
When a range is selected, you can activate the previous cell by:
Answer:
Press Shift + Tab
Shift + Tab moves selection to the previous cell in a range.
370
You can use the formula palette to:
Answer:
Create and edit formulas containing functions
The Formula Palette helps build and edit very complex formulas.