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
51
What do graphics objects on an Excel chart allow you to do?
Answer:
a, b, and c
Graphics on charts can highlight, clarify, or make the data more engaging.
52
Which part of the Excel window displays the data or formula of the active cell?
Answer:
Formula bar
The content of the selected cell is shown in the Formula bar.
53
"Book1" is an example of how ______ are named during each Excel session.
Answer:
Name box
By default, new workbooks are named Book1, Book2, etc.
54
What does the AutoSum button put into the selected cell?
Answer:
The sum of the cell's row unless you adjust the assigned range
AutoSum chooses the adjacent row or column range and enters the SUM formula.
55
What is the first character you must type when entering a formula in Excel?
Answer:
An equal sign
All formulas must start with =.
56
The cell F5 refers to:
Answer:
Column F row 5
The cell address format is column letter first, row number second.
57
Auto Calculate will quickly add selected cells if you:
Answer:
Right-click the status bar and choose Sum
The Auto Calculate feature on the status bar enables rapid summing of cells.
58
Which view displays a blue line around each page to be printed?
Answer:
Page Break Preview
Page Break Preview clearly marks printable pages with blue lines.
59
In spreadsheet terminology, a constant is a:
Answer:
number
Constants are fixed values like numbers or text, not formulas.
60
In Page Break Preview, if rows 1-25 have a white background and row 26 is dark grey, when you print:
Answer:
Only cells with white background will print
Only the areas with a white background are marked for printing in Page Break Preview.