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
7281
Where do you input values and formulas in Excel?
Answer:
Formula Bar
The Formula Bar displays and allows input for active cell data or formulas.
7282
Which symbol is used to join text strings in Excel?
Answer:
Ampersand (&)
You use "&" to link or concatenate text values.
7283
Which symbol is used before a number to treat it as text?
Answer:
Apostrophe (’)
Placing ’ before a value treats it as a label.
7284
Which worksheet elements can be protected from accidental change?
Answer:
All of above
Excel allows you to protect contents, objects, and scenarios.
7285
Which does NOT represent a valid Excel data type?
Answer:
Character
'Character' is not a data type; Excel uses Number, Label, and Date/Time.
7286
Accessing data from cells in another sheet is called:
Answer:
Referencing
Linking to cells on other sheets is known as referencing.
7287
What menu should you use to split the Excel window into two panes?
Answer:
Window > Split
Window > Split splits the current worksheet view.
7288
How can you add a comment to a cell?
Answer:
Insert > Comment
The Insert menu provides the Comment option.
7289
What shortcut is used to replace text/data in cells?
Answer:
Ctrl + H
Ctrl+H opens the Replace dialog for replacing cell content.
7290
To move a worksheet to a whole new workbook, what command should you use?
Answer:
Edit > Move or Copy, select "(new book)" in the dialog
The "To book" dropdown lets you choose "(new book)" to move or copy to a new workbook.