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
341
To remove the content of selected cells, use:
Answer:
Edit » Clear » Contents
This only deletes cell contents, leaves formatting in place.
342
Edit » Delete command:
Answer:
Deletes selected cells
Edit » Delete removes entire cells, shifting adjacent cells.
343
Paste Special allows which operation when pasting to new cells?
Answer:
Divide
"Divide" is a valid Paste Special operation.
344
Paste Special can paste selectively:
Answer:
All of above
Options allow pasting of validation rules, formatting, formulas, etc.
345
Edit » Fill Across Worksheet is active:
Answer:
When many sheets are selected
This command fills data across multiple sheets.
346
Ctrl + R in Excel is used to:
Answer:
Fill the active cell selection to the right
Ctrl + R copies content of the leftmost cell to right.
347
Ctrl + P shortcut in Excel will:
Answer:
Open the print dialog box
Ctrl + P brings up print dialog.
348
To turn a row into columns:
Answer:
Select the cells, then Edit » Paste Special, check Transpose and click OK
This is the main method for transposing rows to columns.
349
Long text can be split into multiple lines within a cell using:
Answer:
Wrap Text in Format » Cells
"Wrap Text" enables multiple lines.
350
You can auto fit the width of a column by:
Answer:
Double-clicking on column right border of column header
This sets optimal width.