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
6661
When defining categories of information in an Excel worksheet, what type of table are you creating?
Answer:
List definition table
When defining categories of information, you're essentially creating a list definition in Excel.
6662
What tool in Excel helps you quickly summarize large data sets?
Answer:
Pivot tables
Pivot tables allow users to summarize large amounts of data for easy analysis and reporting.
6663
Which is a widely known DOS-based spreadsheet?
Answer:
Lotus 1-2-3
Lotus 1-2-3 was an early and popular DOS spreadsheet application.
6664
Which of these cannot be used to link Excel data to a Word document?
Answer:
With the right drag method
Standard methods include hyperlinks and Paste Special, not right-drag.
6665
You can copy data or formulas in Excel using:
Answer:
All of the above
All listed methods can be used for copying data or formulas.
6666
Rounding errors can happen in Excel when:
Answer:
Showing formula results with fewer decimal places than calculated
Rounding errors are noticeable when displayed precision is less than the calculated value.
6667
Which among the following is the earliest spreadsheet program?
Answer:
VisiCalc
VisiCalc was the original spreadsheet application.
6668
Formulas in Excel can include:
Answer:
Value and cell references
Excel formulas can combine hard values and references to cells.
6669
To edit an embedded Excel object in a Word document you should:
Answer:
Use the Excel menu bar and toolbars inside Word
When editing an embedded object, Excel’s menus and tools are accessible within Word.
6670
To keep headings visible while scrolling, use which command?
Answer:
Window menu's Freeze panes
Freeze Panes locks columns and rows so that titles remain in view.