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
6841
If you type 'January 1, 2000' into a cell, Excel treats it as:
Answer:
Value
Recognized dates are stored as numerical values.
6842
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.
6843
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."
6844
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.
6845
Which of these is not a "what-if analysis" tool in Excel?
Answer:
Auto Outline
Auto Outline organizes data, not for what-if analysis.
6846
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.
6847
Which Excel add-in allows you to convert worksheet data and charts to an HTML file?
Answer:
Internet assistant wizard
The Internet Assistant Wizard helps save Excel workbooks as HTML documents for web use.
6848
For creating or editing formulas with functions, which tool is used?
Answer:
Formula palette
The Formula Palette helps insert and edit formulas efficiently.
6849
How can you use the Format Painter multiple times?
Answer:
Double-click the Format Painter button
Double-clicking Format Painter locks it for repeated use.
6850
What is the default file extension for saved Excel files?
Answer:
Xls
Excel files are saved with the .xls extension by default.