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
621
MS Excel is fundamentally designed to run on which operating system?
Answer:
WINDOWS
Microsoft Excel was originally developed for the Windows platform.
622
In Excel, what is meant by the term "Workspace"?
Answer:
A collection of workbooks
A workspace allows you to save the layout of multiple workbooks that you can open together later.
623
An Excel workbook consists of...
Answer:
Worksheets and Charts
Workbooks include both worksheets and chart sheets.
624
How can you carry out several calculations with one formula in Excel?
Answer:
Array Formula
Array formulas can perform multiple computations on matching series of values.
625
Where do you input values and formulas in Excel?
Answer:
Formula Bar
The Formula Bar displays and allows input for active cell data or formulas.
626
Which symbol is used to join text strings in Excel?
Answer:
Ampersand (&)
You use "&" to link or concatenate text values.
627
Which symbol is used before a number to treat it as text?
Answer:
Apostrophe (’)
Placing ’ before a value treats it as a label.
628
Which worksheet elements can be protected from accidental change?
Answer:
All of above
Excel allows you to protect contents, objects, and scenarios.
629
Which does NOT represent a valid Excel data type?
Answer:
Character
'Character' is not a data type; Excel uses Number, Label, and Date/Time.
630
Accessing data from cells in another sheet is called:
Answer:
Referencing
Linking to cells on other sheets is known as referencing.