Computer Science - IT MCQs
Topic Notes: Computer Science - IT
<p>MCQs and preparation resources for competitive exams, covering important concepts, past papers, and detailed explanations.</p>
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
2141
Which is NOT true for Conditional Formatting?
Answer:
Conditions can check for Bold and apply Italics
You cannot set a condition to check for formatting such as Bold and respond with another format like Italics.
2142
What can be evaluated in Conditional Formatting?
Answer:
Both of above
Conditions can be based on values or formulas.
2143
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.
2144
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.
2145
Where can you set the shading color for a cell range?
Answer:
All of above
Shading can be applied using any of these tools.
2146
How can you remove borders from cells?
Answer:
Both of above
Borders can be cleared either way.
2147
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.
2148
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.
2149
Merge Cells can be done from:
Answer:
Both of above
Merge options are available on the Formatting toolbar and Alignment tab.
2150
The Special category under Format Cells > Number can be used for:
Answer:
Both of above
Special formats include Zip Code and Phone Number formatting.