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
221
Which character is used to join (concatenate) text in Excel?
Answer:
Ampersand (&)
The "&" symbol connects or combines text from different cells or strings.
222
To treat a number as a text label, you precede it with which symbol?
Answer:
Apostrophe (')
Start a cell entry with an apostrophe to enter numbers as text.
223
What worksheet elements can you safeguard from unintentional changes?
Answer:
All of the above
You can protect contents, scenarios, and objects to prevent unwanted edits.
224
When can rounding errors occur in Excel?
Answer:
During multiplication, division, or exponentiation
Such operations can introduce floating point rounding errors.
225
Which is the earliest spreadsheet program?
Answer:
VisiCalc
VisiCalc was the pioneering spreadsheet application.
226
Where are status indicators found in Excel?
Answer:
Formula bar
Status indicator icons (like “Enter” and “Edit”) are on the formula bar.
227
When writing formulas, you can use:
Answer:
Either values or cell references, or both
Both numeric values and cell addresses can be used in a formula.
228
To edit an embedded Excel sheet within Word:
Answer:
Use Excel menus and toolbars inside Word
Embedded objects let you use Excel features right in Word.
229
What feature holds row or column headings in place when scrolling?
Answer:
Freeze Panes command
Freeze Panes keeps your headers visible as you scroll.
230
Where can you input numbers or formulas in Excel?
Answer:
Formula bar
The Formula Bar is where data or formulas are entered.