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
191
Which Excel add-in allows you to convert worksheet data and charts to an HTML file?
Answer:
Internet assistant wizard
The Internet Assistant Wizard helps save Excel workbooks as HTML documents for web use.
192
For creating or editing formulas with functions, which tool is used?
Answer:
Formula palette
The Formula Palette helps insert and edit formulas efficiently.
193
How can you use the Format Painter multiple times?
Answer:
Double-click the Format Painter button
Double-clicking Format Painter locks it for repeated use.
194
What is the default file extension for saved Excel files?
Answer:
Xls
Excel files are saved with the .xls extension by default.
195
What does an Excel workbook comprise?
Answer:
Worksheets and charts
An Excel file (workbook) includes both data sheets and chart sheets.
196
Which is a classic DOS-based spreadsheet software?
Answer:
Lotus 1-2-3
Lotus 1-2-3 was widely used in DOS environments.
197
Which method cannot be used to link Excel data to Word?
Answer:
Pasting via standard toolbar’s copy and paste
Standard copy and paste won’t create a data link.
198
Data or formulas can be copied in Excel by:
Answer:
All of the above
Excel permits copying using multiple methods.
199
Which programming language is used to write macros in Excel?
Answer:
Visual Basic
Macros in Excel are programmed with Visual Basic for Applications (VBA).
200
What is the correct method to reference cell A10 from Sheet1, in another sheet?
Answer:
Sheet1!A10
You refer to cells from other sheets using the format SheetName!CellReference.