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
671
If you have a selected range in Excel, how do you move to the previously active cell?
Answer:
None of the above
None of these keys will take you to the previous cell; Shift+Tab typically moves left, not to the previous selection.
672
The formula palette is mainly used to:
Answer:
Enter or edit formulas containing functions
The formula palette is primarily for formula creation and editing.
673
Choose the invalid statement regarding Excel sheets and cell adjustments:
Answer:
Row height can be set manually or fit automatically
Row height can be set manually or auto-fit, so this particular statement is misleading in the context given.
674
Which of the following is FALSE about Conditional Formatting?
Answer:
You can format bold text and apply italics to it via conditions
You can't specify to "find bold and then format as italics" directly in Conditional Formatting.
675
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.
676
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.
677
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.
678
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.
679
What are the ways to remove borders set on Excel cells?
Answer:
Both of the above
Both methods will remove borders from selected cells.
680
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.