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
6701
To insert a hyperlink in an Excel worksheet quickly, press:
Answer:
Ctrl + K
The shortcut Ctrl + K brings up the hyperlink dialog.
6702
Which keyboard shortcut opens the Format Cells dialog box in Excel?
Answer:
Ctrl + 1
Pressing Ctrl + 1 opens the Format Cells dialog.
6703
Every macro keyboard shortcut in Excel includes which key?
Answer:
Ctrl
Macro shortcuts begin with Ctrl plus another key.
6704
Tab scrolling buttons in Excel allow you to:
Answer:
View additional sheet tabs
These buttons enable you to see other worksheet tabs not fully visible on the screen.
6705
Labels can be added to:
Answer:
All
Excel allows you to label any data marker, series, or all items on a chart.
6706
What is the function of SUMIF in Excel?
Answer:
Adds cell values based on a specified condition
SUMIF totals cells that meet certain criteria.
6707
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.
6708
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.
6709
"Book1" is an example of how ______ are named during each Excel session.
Answer:
Name box
By default, new workbooks are named Book1, Book2, etc.
6710
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.