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
121
What does the Autofill feature NOT do?
Answer:
None of the above
Autofill does not do any of these except extend a series, so "none of the above" is the right answer as all others are incorrect.
122
When copying a formula, what does Excel do?
Answer:
Edits the cell references in the pasted formula
Excel updates relative references when copying formulas.
123
What is the latest version among these options?
Answer:
Excel XP
Excel XP is the name for Excel 2002.
124
When copying with drag and drop, which key should you press?
Answer:
End
Using the End key is often required for copying via drag and drop in many Excel configurations.
125
Which is NOT a worksheet design goal?
Answer:
Description
Description is part of documentation, not a direct design criterion.
126
Comments can be added to cells via:
Answer:
Insert > Comments
You add comments using the Insert menu.
127
To delete an embedded Excel object, you should:
Answer:
Select it, then press Delete
Selecting then deleting will remove the embedded object.
128
Files created with Lotus 1-2-3 use which extension?
Answer:
123
Lotus 1-2-3 files get the .123 extension.
129
What should documentation for an Excel workbook include?
Answer:
All of the above
Good documentation covers all these elements.
130
How can you delete a specific record in Excel’s Data Form?
Answer:
Use Data > Form, find the record, click Delete
The Data Form dialog lets you delete individual records.