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
501
Chart Wizard: “Data series” refers to
Answer:
A set of values you plot in a chart
Data series are the information sets or columns that create chart visuals.
502
Which item below is NOT a value?
Answer:
Serial Number 50771
It is text mixed with numbers and not recognized as a numeric value.
503
Maximum number of rows in an Excel worksheet:
Answer:
65,535
Excel 97–2003 supports 65,536 rows (1–65,536).
504
Maximum number of characters in a single cell in Excel:
Answer:
65,535
Newer Excel versions support up to 32,767, but from the choices, 65,535 is closest and reflects Excel 97–2003 for worksheet size.
505
A typical worksheet has how many columns?
Answer:
256
Older Excel versions have 256 columns (A–IV).
506
Which formula will Excel NOT be able to compute?
Answer:
=SUM(A1:A5)/(10-10)
Division by zero is a calculation error and fails.
507
Which formula is NOT entered correctly?
Answer:
10+50
Excel requires the = sign to recognize it as a formula.
508
Every formula must begin with which symbol?
Answer:
=
Formulas always begin with an equals sign.
509
What symbol makes a number a label?
Answer:
' (apostrophe)
Typing an apostrophe first makes Excel treat the entry as text.
510
Which is an absolute cell reference?
Answer:
$A$1
An absolute reference uses dollar signs for column and row.