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
1
What is a good practice when creating a worksheet in Excel?
Answer:
Placing titles for columns in the first row
It's best to use the first row to title the columns for easy reference and understanding of the data.
2
In creating a custom filter in Excel, which is not a Boolean operator?
Answer:
If
"If" is a conditional function, but it is not a Boolean operator like "And," "Or," and "Not" which are used in filters to combine criteria.
3
To highlight information in a worksheet based on certain criteria, you would use which tool in Excel?
Answer:
Conditional format
Conditional formatting in Excel is used to highlight data that meets specific conditions or criteria.
4
To limit the data displayed on an Excel worksheet, you would use which function?
Answer:
Filter
The filter function in Excel allows you to show only specific data that meets certain criteria.
5
When defining categories of information in an Excel worksheet, what type of table are you creating?
Answer:
List definition table
When defining categories of information, you're essentially creating a list definition in Excel.
6
What tool in Excel helps you quickly summarize large data sets?
Answer:
Pivot tables
Pivot tables allow users to summarize large amounts of data for easy analysis and reporting.
7
Which is a widely known DOS-based spreadsheet?
Answer:
Lotus 1-2-3
Lotus 1-2-3 was an early and popular DOS spreadsheet application.
8
Which of these cannot be used to link Excel data to a Word document?
Answer:
With the right drag method
Standard methods include hyperlinks and Paste Special, not right-drag.
9
You can copy data or formulas in Excel using:
Answer:
All of the above
All listed methods can be used for copying data or formulas.
10
Rounding errors can happen in Excel when:
Answer:
Showing formula results with fewer decimal places than calculated
Rounding errors are noticeable when displayed precision is less than the calculated value.