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
6911
Which button do you click to add up numbers?
Answer:
The AutoSum button
The AutoSum (∑) quickly adds a series of numbers.
6912
To activate the previous cell in a preselected range, press:
Answer:
None of the above
Shift + Tab is the correct shortcut.
6913
To move to the previous worksheet, press:
Answer:
Ctrl + PgUp
Ctrl + PgUp moves to the previous sheet tab.
6914
You can add a hyperlink by pressing:
Answer:
Ctrl + K
Ctrl + K is the shortcut to insert a hyperlink.
6915
To open the Format Cells dialog box, press:
Answer:
Ctrl + 1
Ctrl + 1 opens Format Cells.
6916
All macro keyboard shortcuts include the _____ key.
Answer:
Ctrl
Macros always use Ctrl plus a letter or additional key.
6917
You can insert labels for:
Answer:
All
Labels can be added to individual markers, series, or all at once.
6918
What does the SUMIF function do?
Answer:
Adds up cell values based on a condition
SUMIF totals values only where a condition is met.
6919
Graphics objects on a chart are used to:
Answer:
All of the above
Graphics enhance charts visually and functionally.
6920
Which displays the content of the active cell?
Answer:
Formula bar
The formula bar shows what’s in the selected cell.