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
261
You can insert labels for:
Answer:
All
Labels can be added to individual markers, series, or all at once.
262
What does the SUMIF function do?
Answer:
Adds up cell values based on a condition
SUMIF totals values only where a condition is met.
263
Graphics objects on a chart are used to:
Answer:
All of the above
Graphics enhance charts visually and functionally.
264
Which displays the content of the active cell?
Answer:
Formula bar
The formula bar shows what’s in the selected cell.
265
"Book1" is an example of how __________ are named during a session.
Answer:
Name box
Book1 is the default name for new Excel workbooks.
266
Using the AutoSum button will replace the selected cell with:
Answer:
The sum of values in the cell's column or row
AutoSum adds up numbers above or to the left automatically.
267
When typing an equation in a cell, the first thing you must enter is:
Answer:
An equal sign
All formulas must start with "=".
268
The cell labeled F5 refers to:
Answer:
Column F, row 5
F5 means the cell at column F and row 5.
269
Auto Calculate will quickly total selected cells if you:
Answer:
Right-click the status bar and select Sum
AutoCalculate options appear by right-clicking the status bar.
270
The view that puts a blue line around each page to be printed is:
Answer:
Page Break Preview
This mode shows printable areas and page divisions.