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
7001
Edit » Fill Across Worksheet is active:
Answer:
When many sheets are selected
This command fills data across multiple sheets.
7002
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.
7003
Ctrl + P shortcut in Excel will:
Answer:
Open the print dialog box
Ctrl + P brings up print dialog.
7004
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.
7005
Long text can be split into multiple lines within a cell using:
Answer:
Wrap Text in Format » Cells
"Wrap Text" enables multiple lines.
7006
You can auto fit the width of a column by:
Answer:
Double-clicking on column right border of column header
This sets optimal width.
7007
Which pointer lets you move content to other cells?
Answer:
Mouse pointer with anchor at tip
The four-headed arrow or anchor allows moving content.
7008
To fill a series, Excel uses which pointer?
Answer:
Small thin plus icon
The small black plus (fill handle) is used to fill series.
7009
Which cell pointer indicates you can make a selection?
Answer:
Doctor's symbol (Big Plus)
The large white plus is the selection pointer.
7010
Letting long text flow into adjacent cells is acceptable when:
Answer:
No data will be entered in the adjacent cells
Long text only displays if adjacent cells are empty.