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
7121
If you want text in a cell to appear on multiple lines, which option should you use?
Answer:
Format, cells, alignment
Text wrapping is set through the Alignment tab in Format Cells.
7122
Which function will display today’s date (without time) in a cell in Excel?
Answer:
today()
The TODAY() function returns only the current date.
7123
What function would you use in Excel to insert the current date and time?
Answer:
now()
The NOW() function gives both current date and time.
7124
If you apply the format code "#,##0.00" to the value 5436.8, what result will Excel display?
Answer:
5436.80
The format "#,##0.00" displays numbers with two decimal places, so 5436.8 shows as 5436.80.
7125
Which types of charts can you create in Excel?
Answer:
All of the above
Excel supports a variety of chart types including Area, Line, Pie, and more.
7126
How do you organize data to be in order from smallest to largest or largest to smallest?
Answer:
Data, Sort
The Sort feature in the Data menu arranges your data in ascending or descending order.
7127
Microsoft Excel is categorized as a:
Answer:
Spreadsheet application
Excel is a powerful program primarily used for creating and managing spreadsheets.
7128
Which operation is NOT performed by "Edit, Clear" in Excel?
Answer:
Delete entire cells
"Edit, Clear" can clear formats, contents, or comments, but does not delete the cells themselves.
7129
Which of the following functions is NOT available in the Consolidate dialog in Excel?
Answer:
Pmt
The PMT function is not part of the functions you can use in the Consolidate feature.
7130
Which Excel function returns the remainder of a division operation?
Answer:
MOD()
MOD() calculates the remainder after dividing one number by another.