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
7331
When setting up Conditional Formatting, you can set conditions based on:
Answer:
Both of the above
Conditional Formatting works with both direct cell values and custom formulas.
7332
If you want all values between 0 and 100 to display in red text, what should you use?
Answer:
Conditional Formatting
Conditional Formatting is designed to apply formats (like colors) based on actual cell values.
7333
Where can you set a page border in Excel?
Answer:
Page border cannot be set in Excel
Unlike Word, Excel doesn’t support page borders as a feature.
7334
How do you apply color shading to a group of cells in Excel?
Answer:
All of the above
Shading can be applied through multiple locations, such as toolbars and Format Cells.
7335
What are the ways to remove borders set on Excel cells?
Answer:
Both of the above
Both methods will remove borders from selected cells.
7336
In the AutoFormat dialog box, which type(s) of formatting can you choose to include or omit?
Answer:
All of the above
AutoFormat allows you to independently select number, border, and font formats to apply.
7337
What do we call the vertical divisions in a table?
Answer:
Column
No explanation is given for this question.
Let's Discuss on Board
7338
What program type best supports statistical calculations?
Answer:
Spreadsheet
No explanation is given for this question.
Let's Discuss on Board
7339
Which application is ideal for statistical and numerical analysis?
Answer:
Spreadsheet
No explanation is given for this question.
Let's Discuss on Board
7340
In MS Word/Excel, Ctrl + Y is used to:
Answer:
Redo
No explanation is given for this question.
Let's Discuss on Board