Computer Science - IT MCQs
Topic Notes: Computer Science - IT
<p>MCQs and preparation resources for competitive exams, covering important concepts, past papers, and detailed explanations.</p>
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
2191
What is the default step value in the Fill Series dialog box?
Answer:
1
“1” is filled by default if you don’t specify a different interval.
2192
To split text into multiple lines within one cell, use:
Answer:
Wrap Text in Format >> Cells
“Wrap Text” ensures text appears on multiple lines inside a cell.
2193
To auto-fit the width of a column, you should:
Answer:
Double-click column right border in header
This automatically resizes to fit content.
2194
What pointer icon do you see when moving contents to another cell?
Answer:
Anchor-tipped mouse pointer
The anchor pointer indicates dragging and moving data.
2195
Which pointer means you can fill a series by dragging?
Answer:
Small thin plus
The skinny plus lets you drag-fill a sequence.
2196
Which pointer shape lets you select multiple cells?
Answer:
Doctor’s symbol (big plus)
The big plus cursor is for cell range selection.
2197
It’s fine to let text spill into adjacent cells when:
Answer:
No data will be added to adjacent cells
If adjacent cells are empty, text will display in full across columns.
2198
How do you convert a column of data to a row?
Answer:
Edit >> Paste Special >> Transpose
Paste Special with the Transpose option will flip columns to rows.
2199
Which is NOT a choice in Excel’s Paste Special dialog?
Answer:
SQRT
Add, subtract, and divide are options, but “SQRT” is not.
2200
What does Ctrl + X do after selecting cells in Excel?
Answer:
Marks the region for cutting (can paste)
Ctrl+X marks cells to cut so they can be pasted elsewhere.