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
21
Which tabs are present in Excel's Help menu?
Answer:
All of the above
The help menu in Excel includes Contents, Answer Wizard, and Index tabs.
22
What is the purpose of the Fill Color button on the Formatting toolbar in Excel?
Answer:
To add shading or color to a cell range
This button applies color to the selected cells.
23
In Excel, what is meant by a Data Series?
Answer:
A collection of related data
A data series is a sequence of related numbers used in charts and graphs.
24
What does the small black square in the lower-right corner of an active cell or range represent?
Answer:
Fill handle
The fill handle is used to quickly extend values or formulas to adjacent cells.
25
What are the tabs at the bottom of an Excel workbook called?
Answer:
Sheet tabs
These are labeled tabs showing worksheet names at the bottom of the workbook window.
26
What is created when you add dollar signs ($) to a cell address?
Answer:
An absolute cell address
The $ sign locks the reference, making it absolute.
27
What is the label of the very first cell in an Excel worksheet?
Answer:
A1
Excel labels its first cell as A1, representing column A and row 1.
28
How can you secure a workbook in Excel?
Answer:
Any of the above
Any of these options can be used to save or protect an Excel workbook.
29
What feature allows you to record and replay keyboard and mouse actions in Excel?
Answer:
Macro Recorder
Macro Recorder captures a sequence of actions for automation.
30
Which function key is pressed to run Spelling Check?
Answer:
F7
Pressing F7 initiates a spelling check in Excel.