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
181
Paste Special in Excel lets you:
Answer:
Paste resulting values from a formula instead of the formula
You can use Paste Special > Values to paste only computed values.
182
What is the correct order of operations in Excel calculations?
Answer:
All of the above illustrate parts of the correct order
All options describe aspects of Excel’s operator precedence.
183
What do all worksheet formulas ultimately do?
Answer:
Return a result
Formulas always compute and return a value.
184
Which kinds of data can you enter into Excel cells?
Answer:
Labels, values, and formulas
Cells can contain text, numbers, or formulas.
185
If you type 'January 1, 2000' into a cell, Excel treats it as:
Answer:
Value
Recognized dates are stored as numerical values.
186
Why is an Excel file called a "workbook"?
Answer:
It holds many different sheets, both worksheets and charts
Workbooks can include several worksheets and chart sheets.
187
When using Solver in Excel, which is NOT a setting you can specify?
Answer:
Input cells
Solver requires you to set changing cells, a target cell, and constraints, but not general "input cells."
188
When you insert an Excel file into a Word document, the data is:
Answer:
Linked
Inserted Excel data can be linked so it updates with changes in the original file.
189
Which of these is not a "what-if analysis" tool in Excel?
Answer:
Auto Outline
Auto Outline organizes data, not for what-if analysis.
190
In Excel, what is a circular reference?
Answer:
A formula that refers to itself, directly or indirectly
Circular references occur when a formula depends on its own result.