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
6961
Which is NOT a What IF analysis tool?
Answer:
Macros
Macros automate tasks—not for What IF analysis.
6962
To apply Goal Seek, your cell pointer must be in:
Answer:
The Result Cell where formula is entered
Your pointer must be on the output (result) cell.
6963
Which tool lets you find the needed value of a cell to achieve a desired result?
Answer:
Goal Seek
Goal Seek finds required input for a given output.
6964
Excel is a good application for What IF analysis. Which tool helps?
Answer:
Goal Seek
Goal Seek lets you test outcomes for different input values.
6965
Which option is NOT available for removing arrows in Formula Auditing?
Answer:
Remove all arrows for this cell
There is no command to remove only the arrows related to a single cell.
6966
Remove arrows from Auditing by:
Answer:
Both of above
Both methods work to clear trace arrows.
6967
Trace Dependence (Auditing) shows:
Answer:
In which formula the current cell is used
Trace Dependence reveals the formulas relying on current cell’s value.
6968
Trace Precedence (Auditing) shows:
Answer:
Which cells are used in current formula
Trace Precedence traces inputs to the current cell.
6969
Which is invalid regarding Protection in Excel?
Answer:
All above are valid
All listed protection options exist.
6970
Shortcut key to replace data:
Answer:
Ctrl + H
Ctrl + H opens the Replace dialog.