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
311
Trace Dependence (Auditing) shows:
Answer:
In which formula the current cell is used
Trace Dependence reveals the formulas relying on current cell’s value.
312
Trace Precedence (Auditing) shows:
Answer:
Which cells are used in current formula
Trace Precedence traces inputs to the current cell.
313
Which is invalid regarding Protection in Excel?
Answer:
All above are valid
All listed protection options exist.
314
Shortcut key to replace data:
Answer:
Ctrl + H
Ctrl + H opens the Replace dialog.
315
To move a sheet to a new workbook:
Answer:
All of above
All these steps are involved in moving/copying to a new book.
316
Which is NOT true about Find and Replace in Excel?
Answer:
You can search for bold and replace with italics
Excel Find and Replace cannot search/replace by text style alone.
317
About Find and Replace in Excel, which is valid?
Answer:
You can Find and Replace within the sheet or workbook
Scope can be changed to sheet or entire workbook.
318
To remove a sheet from workbook:
Answer:
Select the sheet, then choose Edit » Delete Sheet
Delete Sheet removes it permanently, Hide just makes it invisible.
319
If Excel worksheet data is linked to a Word document:
Answer:
The Word document holds a reference to Excel’s data
Linked data means Word keeps a reference to the original workbook.
320
What can be selected in a worksheet?
Answer:
All of the above
Excel lets you select rows, columns, or the whole sheet at once.