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
7071
Excel worksheet cells are similar to which Windows GUI component?
Answer:
Text boxes
Individual cells operate like single-line text boxes for entering/editing data.
7072
Which is NOT a valid data type in Excel?
Answer:
Character
"Character" is not specifically recognized; "Label" is used for text.
7073
How can you change worksheet numbers like "1000" to "$1,000.00"?
Answer:
Click the Currency Style button on the formatting toolbar
The Currency button quickly formats numbers as money.
7074
The Paste Special command allows you to:
Answer:
Copy only formatting
Paste Special can paste formatting, values, comments, and perform math operations.
7075
Which is the correct precedence order for formulas?
Answer:
Multiplication/division, positive/negative, addition/subtraction
Order is typically exponents, then multiply/divide, then add/subtract.
7076
All worksheet formulas:
Answer:
Return a formula result
All formulas ultimately produce an output result.
7077
You may enter the following data types into worksheet cells:
Answer:
Labels, values, and formulas
All these are acceptable input types in cells.
7078
Excel will interpret "January 1, 2000" entered into a cell as:
Answer:
Value
Excel automatically treats recognizable date entries as values.
7079
Why is an Excel file called a workbook?
Answer:
It can contain multiple sheets, including charts and worksheets
A workbook is a collection of sheets and chart sheets in one file.
7080
What can you NOT specify using Solver?
Answer:
Input cells
"Input cells" is not a Solver option; you specify target, changing, and constraints.