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
321
Which tool lets you copy format from one area and apply it to another?
Answer:
The Format Painter button
The Format Painter button on the toolbar copies and applies formatting.
322
When the formula bar is in use, which of the following is displayed?
Answer:
All of the above
All these controls are on the formula bar when activated.
323
Which button do you click to add numbers in a range automatically?
Answer:
The autosum button
AutoSum automates summing up rows or columns.
324
In a selected cell range, how do you move back to the previously active cell?
Answer:
None of the above
None of these keys specifically return you to the previous cell in a selection.
325
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.
326
Which type of formula allows multiple calculations at once in Excel?
Answer:
Array formula
Array formulas can process multiple calculations in one step.
327
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.
328
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.
329
What are comments inserted in worksheet cells called?
Answer:
Cell Tip
Comments are often known as cell tips or cell comments.
330
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.