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
6851
What does an Excel workbook comprise?
Answer:
Worksheets and charts
An Excel file (workbook) includes both data sheets and chart sheets.
6852
Which is a classic DOS-based spreadsheet software?
Answer:
Lotus 1-2-3
Lotus 1-2-3 was widely used in DOS environments.
6853
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.
6854
Data or formulas can be copied in Excel by:
Answer:
All of the above
Excel permits copying using multiple methods.
6855
Which programming language is used to write macros in Excel?
Answer:
Visual Basic
Macros in Excel are programmed with Visual Basic for Applications (VBA).
6856
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.
6857
Where does Excel display the address of the currently active cell?
Answer:
Name Box
The Name Box shows the address or name of the selected cell.
6858
Which symbol is used in a formula to make columns or rows absolute?
Answer:
$
The dollar sign $ keeps rows or columns fixed in formulas.
6859
Which shortcut highlights the entire column in Excel?
Answer:
Ctrl+SpaceBar
Use Ctrl + SpaceBar to select the current column.
6860
How can you wrap text within a cell in Excel?
Answer:
Format cells, alignment
Go to Format → Cells → Alignment to enable text wrapping in a cell.