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
211
The "Edit, Clear" command cannot be used to:
Answer:
Delete cells
"Edit, Clear" removes content, notes, or formatting, but not the actual cells themselves.
212
Which of the following is unavailable in the Consolidate dialog in Excel?
Answer:
Pmt
Functions like Average, Max, and Sum are available, but PMT is not present in the Consolidate dialog.
213
Which function returns the remainder after dividing a number by a divisor in Excel?
Answer:
MODQ
MOD returns the remainder after division.
214
Which shortcut selects an entire column in Excel?
Answer:
Ctrl + SpaceBar
Pressing Ctrl + SpaceBar highlights the entire column.
215
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.
216
Which operating system is MS-Excel primarily designed for?
Answer:
Windows
MS-Excel is developed mainly to work on the Windows platform.
217
How would you define a Workspace in Excel?
Answer:
Group of Workbooks
A workspace represents a group of workbooks saved to be opened together.
218
What does an Excel Workbook consist of?
Answer:
Worksheets and Charts
A workbook includes a collection of worksheets and charts.
219
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.
220
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.