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
301
Where do a row and a column intersect in Excel?
Answer:
A cell
Each intersection of a row and a column creates a cell in a spreadsheet.
302
When you start typing a value already present in the same column, Excel auto-suggests using:
Answer:
AutoComplete
AutoComplete fills in repetitive entries automatically in a column.
303
By default, pressing Enter moves cell pointer down. To change this:
Answer:
Tools » Options » Edit tab
The Edit tab allows configuring Enter key behavior.
304
With Manual Calculation mode ON, which key updates formula values?
Answer:
F9
Pressing F9 recalculates all open workbooks.
305
Which is NOT a What IF analysis tool?
Answer:
Macros
Macros automate tasks—not for What IF analysis.
306
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.
307
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.
308
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.
309
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.
310
Remove arrows from Auditing by:
Answer:
Both of above
Both methods work to clear trace arrows.