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
111
In the context of the Chart Wizard, what does the term "data series" mean?
Answer:
A collection of chart data markers
A data series is a group of related data points represented by markers in a chart.
112
Which item below would NOT be considered a value in Excel terminology?
Answer:
Serial Number 50771
Values in Excel are numbers or dates; “Serial Number 50771” is treated as text because it contains letters.
113
What is the maximum number of rows in a worksheet?
Answer:
65,535
Older Excel versions support up to 65,535 rows per sheet.
114
How many characters may be entered in a single cell?
Answer:
65,535
Each cell can contain up to 65,535 characters.
115
How many columns are in a standard worksheet?
Answer:
256
Early versions of Excel provide 256 columns per sheet.
116
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.
117
Which formula is NOT correctly written for Excel?
Answer:
10+50
Without the leading "=", it’s not a formula.
118
All Excel formulas begin with what symbol?
Answer:
=
The equals sign tells Excel you're writing a formula.
119
Which symbol before a number turns it into a label?
Answer:
(apostrophe) '
Use a single apostrophe to make a number display as text.
120
What menu is used to split Excel’s window into multiple panes?
Answer:
Window > split
The Split command is on the Window menu.