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
421
You may enter the following data types into worksheet cells:
Answer:
Labels, values, and formulas
All these are acceptable input types in cells.
422
Excel will interpret "January 1, 2000" entered into a cell as:
Answer:
Value
Excel automatically treats recognizable date entries as values.
423
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.
424
What can you NOT specify using Solver?
Answer:
Input cells
"Input cells" is not a Solver option; you specify target, changing, and constraints.
425
When you insert an Excel file into Word, the data are:
Answer:
Embedded
Default insertion embeds the spreadsheet in the Word file.
426
Which of these is NOT an Excel what-if analysis tool?
Answer:
Auto Outline
Auto Outline is for grouping, not for what-if analysis.
427
A circular reference is:
Answer:
A formula that refers to itself directly or indirectly
A circular reference occurs when the formula's calculation loop refers back to itself.
428
To convert Excel data/charts to HTML, use:
Answer:
Internet Assistant Wizard
The Internet Assistant Wizard exports spreadsheets to HTML.
429
The Formula Palette is used to:
Answer:
Create and edit formulas containing functions
The Formula Palette helps you select and insert functions.
430
What’s the fastest way to select an entire column?
Answer:
Click the column heading letter
Clicking the header letter highlights the whole column.