Computer Science - IT MCQs
Topic Notes: Computer Science - IT
<p>MCQs and preparation resources for competitive exams, covering important concepts, past papers, and detailed explanations.</p>
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
2161
Which tool button enables you to quickly total up a range of values in Excel?
Answer:
AutoSum
The AutoSum button automatically inserts a formula to sum up selected data.
2162
MS Excel is fundamentally designed to run on which operating system?
Answer:
WINDOWS
Microsoft Excel was originally developed for the Windows platform.
2163
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.
2164
An Excel workbook consists of...
Answer:
Worksheets and Charts
Workbooks include both worksheets and chart sheets.
2165
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.
2166
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.
2167
Which symbol is used to join text strings in Excel?
Answer:
Ampersand (&)
You use "&" to link or concatenate text values.
2168
Which symbol is used before a number to treat it as text?
Answer:
Apostrophe (’)
Placing ’ before a value treats it as a label.
2169
Which worksheet elements can be protected from accidental change?
Answer:
All of above
Excel allows you to protect contents, objects, and scenarios.
2170
Which does NOT represent a valid Excel data type?
Answer:
Character
'Character' is not a data type; Excel uses Number, Label, and Date/Time.