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
471
Microsoft Excel is categorized as a:
Answer:
Spreadsheet application
Excel is a powerful program primarily used for creating and managing spreadsheets.
472
Which operation is NOT performed by "Edit, Clear" in Excel?
Answer:
Delete entire cells
"Edit, Clear" can clear formats, contents, or comments, but does not delete the cells themselves.
473
Which of the following functions is NOT available in the Consolidate dialog in Excel?
Answer:
Pmt
The PMT function is not part of the functions you can use in the Consolidate feature.
474
Which Excel function returns the remainder of a division operation?
Answer:
MOD()
MOD() calculates the remainder after dividing one number by another.
475
What menu lets you split windows in Excel?
Answer:
Window > Split
This divides the worksheet to see multiple areas at once.
476
The AutoFill feature:
Answer:
Extends a sequential series
AutoFill is used to continue series like numbers, days, or months.
477
When copying a formula:
Answer:
Excel edits cell references in the copy
Relative references are updated appropriately during copy.
478
Which is the latest Excel version from the list?
Answer:
Excel XP
Excel XP (2002) followed Excel 2000.
479
When using drag and drop to copy cells, which key do you press?
Answer:
Ctrl key
Hold Ctrl while dragging to copy instead of move.
480
How are comments added to cells?
Answer:
Insert > Comments
Use Insert > Comment to annotate cells.