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
7101
In Excel, what is a Data Series?
Answer:
A collection of related data points
A data series is a group of related values in a chart.
7102
What is the name for the small black square at a cell’s lower right corner?
Answer:
Fill handle
The Fill Handle is used for quickly filling data or formulas.
7103
What are the names of the tabs showing at the bottom of a worksheet?
Answer:
Sheet tabs
Sheet tabs allow navigation between worksheets.
7104
What effect do dollar signs ($) in a cell address like $B$2:$B$10 have?
Answer:
Makes the reference absolute
Dollar signs fix the reference for copying.
7105
What is the address of the very first cell in Excel?
Answer:
A1
The worksheet starts at cell A1 (first column, first row).
7106
How can you secure or protect your workbook?
Answer:
Any of the above
All these methods provide forms of workbook protection.
7107
Which feature lets you record keyboard and mouse steps for repeat use?
Answer:
Macro Recorder
The Macro Recorder automates keystrokes and commands.
7108
What key do you press to run the Spell Check in Excel?
Answer:
F7
F7 launches Spell Check in most Microsoft Office programs.
7109
The spelling checker dialog can be opened from which menu?
Answer:
Tools
Spelling is under the Tools menu.
7110
Which chart type displays data as parts of a whole?
Answer:
Pie Chart
Pie charts show proportions of a total.