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
91
Which command can be used to instantly restore a record you just deleted in Excel?
Answer:
Undo
Clicking undo immediately recovers a record erased by mistake.
92
To group all white cats together in your database, you would sort by:
Answer:
Pet Type, then Color
Sorting first by pet type and then by color organizes all white cats together.
93
The box within a chart that displays the names of each data category is called the:
Answer:
Legend
The legend explains what each color or symbol in the chart represents.
94
What is required in a spreadsheet to perform calculations?
Answer:
Formula
Calculations in Excel require formulas.
95
To list countries from largest to smallest population, what sort order must be applied?
Answer:
Descending order
Sorting the population field in descending order lists the largest first.
96
Inserting a blank line after a worksheet title is best done by:
Answer:
Insert a row
The proper way to add a blank line is to insert a whole row.
97
To preserve the original worksheet and save edited changes to a new file, you should use:
Answer:
Save As
'Save As' creates a new file, leaving the original unchanged.
98
If you want to record experiment data and create a chart for crystal growth over time, which application should you use?
Answer:
Spreadsheet
Spreadsheets are ideal for recording and graphing experimental data.
99
What is the most effective way to present monthly rainfall data for Nepal in a report?
Answer:
Chart showing rainfall amounts
A chart best represents variations in rainfall data visually.
100
NOT, AND, OR, and XOR in Excel are what type of operators?
Answer:
Logical Operators
These operators perform logical operations in Excel formulas.