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
6871
What's the tool button for summing a large range of numbers in Excel?
Answer:
Auto sum
The Auto sum button adds up selected cells quickly.
6872
Which operating system is MS-Excel primarily designed for?
Answer:
Windows
MS-Excel is developed mainly to work on the Windows platform.
6873
How would you define a Workspace in Excel?
Answer:
Group of Workbooks
A workspace represents a group of workbooks saved to be opened together.
6874
What does an Excel Workbook consist of?
Answer:
Worksheets and Charts
A workbook includes a collection of worksheets and charts.
6875
Which type of formula allows handling multiple calculations at once?
Answer:
Array Formula
Array formulas process multiple values and return either a single result or multiple results.
6876
Where do you type values and formulas in Excel?
Answer:
Formula Bar
The Formula Bar is the area for entering or editing data and formulas for a cell.
6877
Which character is used to join (concatenate) text in Excel?
Answer:
Ampersand (&)
The "&" symbol connects or combines text from different cells or strings.
6878
To treat a number as a text label, you precede it with which symbol?
Answer:
Apostrophe (')
Start a cell entry with an apostrophe to enter numbers as text.
6879
What worksheet elements can you safeguard from unintentional changes?
Answer:
All of the above
You can protect contents, scenarios, and objects to prevent unwanted edits.
6880
When can rounding errors occur in Excel?
Answer:
During multiplication, division, or exponentiation
Such operations can introduce floating point rounding errors.