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
6981
Which of the following can be used to create a hyperlink in Excel?
Answer:
All of the above
Hyperlinks can be attached to various objects: text, images, and drawings.
6982
Which type of formula allows multiple calculations at once in Excel?
Answer:
Array formula
Array formulas can process multiple calculations in one step.
6983
What do the vertical and horizontal scrollbars let you do in a worksheet?
Answer:
See different parts of the worksheet without changing cell selection
Scrollbars are for scrolling, not editing or splitting.
6984
Which of these can be used for “what-if analysis” in Excel?
Answer:
All of the above
Scenario Manager, Goal Seek, and Solver all offer what-if analysis features.
6985
What are comments inserted in worksheet cells called?
Answer:
Cell Tip
Comments are often known as cell tips or cell comments.
6986
Where is the Name Box located in Excel?
Answer:
To the left of the formula bar
The Name Box is always on the left side of the Formula Bar.
6987
If a label is too wide for its Excel cell, what should you do?
Answer:
Widen the column
Increasing the column width will let the entire label be visible.
6988
When combining Word and Excel, Word typically acts as:
Answer:
Both client and destination
In integration, Word is generally the client receiving data, thus is both b and c.
6989
How can you search for specific data within a list in Excel?
Answer:
Use Data > Form and click the Criteria button
The Data Form offers search (criteria) tools for lists.
6990
What’s a quick way to delete an entire column in Excel?
Answer:
Right-click the column header and choose Delete
Right-clicking the column heading and selecting “Delete” is the most direct method.