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
391
Horizontal and vertical scroll bars let you:
Answer:
View different worksheet rows and columns
Scroll bars are primarily for navigating the worksheet area.
392
What is used for what-if analysis?
Answer:
All of above
Excel offers several what-if analysis tools: Goal Seek, Solver, and Scenario Manager.
393
Comments placed in cells are called:
Answer:
Cell tips
Informational comments are displayed as cell tips.
394
The Name box:
Answer:
Appears to the left of the formula bar
It displays the cell reference or name of the current selection.
395
If a label is too long for a cell, you should:
Answer:
Increase the column width
Widening the column allows the full label to be visible.
396
When integrating Word and Excel, Word is usually the:
Answer:
Both B and C
In integrated scenarios, Word acts as both client and destination for Excel data.
397
How do you find specific info in a list?
Answer:
Data > Form, then click Criteria
The Data Form dialog with Criteria option is for list searching.
398
How do you delete a column?
Answer:
Right-click the column header, select Delete
The quickest way is to right-click and delete.
399
To center worksheet titles across a range, you must:
Answer:
Select the title cell and the full range, then use "Merge and Center"
Highlight both the title and desired width before centering.
400
To start a formula in Excel:
Answer:
Select a cell, type the equals sign (=), then input the formula
Formulas must start with = in Excel.