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
7161
A typical worksheet has how many columns?
Answer:
256
Older Excel versions have 256 columns (A–IV).
7162
Which formula will Excel NOT be able to compute?
Answer:
=SUM(A1:A5)/(10-10)
Division by zero is a calculation error and fails.
7163
Which formula is NOT entered correctly?
Answer:
10+50
Excel requires the = sign to recognize it as a formula.
7164
Every formula must begin with which symbol?
Answer:
=
Formulas always begin with an equals sign.
7165
What symbol makes a number a label?
Answer:
' (apostrophe)
Typing an apostrophe first makes Excel treat the entry as text.
7166
Which is an absolute cell reference?
Answer:
$A$1
An absolute reference uses dollar signs for column and row.
7167
The default header for a worksheet is:
Answer:
None
By default, worksheets have no header until you add one.
7168
To use the Format Painter multiple times, you should:
Answer:
Double-click the Format Painter button
Double-clicking keeps Format Painter active until you turn it off.
7169
Grouping worksheets allows you to:
Answer:
B and C
Grouping lets you print, format, and enter data on several worksheets together.
7170
Data markers on a chart are connected to worksheet data, which means:
Answer:
Both A and C
Excel allows formatting and updates through live connections between charts and data.