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
6771
How many columns are in a standard worksheet?
Answer:
256
Early versions of Excel provide 256 columns per sheet.
6772
Excel cannot calculate which type of formula?
Answer:
=SUM(Sales)-A3
If "Sales" is not a range or a defined name, this formula will error.
6773
Which formula is NOT correctly written for Excel?
Answer:
10+50
Without the leading "=", it’s not a formula.
6774
All Excel formulas begin with what symbol?
Answer:
=
The equals sign tells Excel you're writing a formula.
6775
Which symbol before a number turns it into a label?
Answer:
(apostrophe) '
Use a single apostrophe to make a number display as text.
6776
What menu is used to split Excel’s window into multiple panes?
Answer:
Window > split
The Split command is on the Window menu.
6777
What does the Autofill feature NOT do?
Answer:
None of the above
Autofill does not do any of these except extend a series, so "none of the above" is the right answer as all others are incorrect.
6778
When copying a formula, what does Excel do?
Answer:
Edits the cell references in the pasted formula
Excel updates relative references when copying formulas.
6779
What is the latest version among these options?
Answer:
Excel XP
Excel XP is the name for Excel 2002.
6780
When copying with drag and drop, which key should you press?
Answer:
End
Using the End key is often required for copying via drag and drop in many Excel configurations.