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
601
What can be evaluated in Conditional Formatting?
Answer:
Both of above
Conditions can be based on values or formulas.
602
For numbers between 0 and 100 to appear in red, use:
Answer:
Conditional Formatting command from Format menu
Conditional formatting is the correct way to apply such rules.
603
You can set a page border in Excel from:
Answer:
You cannot set a page border in Excel
Excel does not directly offer a "Page Border" feature.
604
Where can you set the shading color for a cell range?
Answer:
All of above
Shading can be applied using any of these tools.
605
How can you remove borders from cells?
Answer:
Both of above
Borders can be cleared either way.
606
In the AutoFormat dialog, which formatting can you choose to apply or not?
Answer:
All of above
You can select/deselect all types of formatting in the AutoFormat dialog.
607
Pre-set formats like Simple, Classic, Accounting, or Colorful can be applied from:
Answer:
Format > AutoFormat
The AutoFormat feature is accessed from the Format menu.
608
Merge Cells can be done from:
Answer:
Both of above
Merge options are available on the Formatting toolbar and Alignment tab.
609
The Special category under Format Cells > Number can be used for:
Answer:
Both of above
Special formats include Zip Code and Phone Number formatting.
610
Which function puts the current time into a worksheet cell?
Answer:
=NOW()
The NOW function returns the current date and time.