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
6891
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.
6892
Which font is used by default in Excel?
Answer:
Arial
The default font in Excel worksheets is Arial.
6893
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.
6894
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.
6895
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.
6896
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.
6897
If you type "Sunday" and drag the fill handle to the right, Excel continues with "Monday," "Tuesday," and so forth. How does Excel know what to fill in next?
Answer:
Custom List
Excel uses predefined custom lists (like days of the week) to fill adjacent cells when you drag the fill handle.
6898
What are the default and maximum numbers of sheets present in a new Excel 2003 workbook?
Answer:
3 and 256
By default, Excel 2003 opens a new workbook with 3 sheets, and you can add up to a total of 256 sheets.
6899
Except for the ______ function, logical formulas show "TRUE" or "FALSE" as output:
Answer:
IF
The IF function can display custom results instead of just TRUE or FALSE, while AND/OR/NOT always return Boolean values.
6900
What function transforms row data to column (or vice versa)?
Answer:
Transpose
TRANSPOSE rearranges orientation of data.