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
231
Identify which one is NOT a valid data type in Excel.
Answer:
Character
Excel doesn't recognize "Character" as a data type; valid types are Label, Number, and Date/Time.
232
What is the act of accessing data from a cell on another worksheet called?
Answer:
Referencing
When you use information from another sheet, it's termed as referencing.
233
Which menu command is suitable for splitting a window into two panes?
Answer:
View → Split
"View → Split" lets you divide your worksheet into multiple panes for easier navigation.
234
Which option allows you to insert comments into cells?
Answer:
Insert → Comment
To add a note to a cell, you use the "Insert → Comment" feature.
235
What is the name for comments added to cells?
Answer:
Cell Tip
Comments inserted in cells serve as cell tips, providing additional information when hovered over.
236
Which font is used by default in Excel?
Answer:
Arial
The default font in Excel worksheets is Arial.
237
The standard font size for text in a new Excel worksheet is:
Answer:
10 points
By default, Excel uses a 10-point font for new worksheets.
238
What occurs if you uncheck the box for Row & Column headers under Options?
Answer:
Column and row labels of your data disappear
Turning off this setting hides both column letters and row numbers from the worksheet display.
239
Which of these cannot be hidden from Tools > Options in the View tab?
Answer:
Status bar
In Excel, the status bar cannot be hidden through the Tools > Options > View tab, while others can be shown or hidden.
240
What are the minimum and maximum values for setting Save AutoRecovery Info in Excel?
Answer:
1 and 120 minutes
You can configure AutoRecovery in Excel to save your work as frequently as every 1 minute and up to every 120 minutes.