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
7301
Which is not a valid Fill Series type?
Answer:
Time
“Time” is not a direct series type; Linear, Growth, and Autofill are.
7302
When does the Edit >> Fill Across Worksheet command become active?
Answer:
Multiple sheets selected
It only works with more than one worksheet active.
7303
Ctrl + R performs which action?
Answer:
Fills selection to the right with contents of the active cell
Ctrl+R copies and pastes values to the right in a selected range.
7304
Ctrl + D in Excel does what?
Answer:
Fill down
Ctrl+D quickly copies content from the cell above down into the selected range.
7305
To convert a row of data into a column, how should you proceed?
Answer:
Copy, go to a new cell, then Paste Special > Transpose, and click OK
You should copy the row, select your target, and transpose with Paste Special.
7306
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.
7307
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.
7308
To auto-fit the width of a column, you should:
Answer:
Double-click column right border in header
This automatically resizes to fit content.
7309
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.
7310
Which pointer means you can fill a series by dragging?
Answer:
Small thin plus
The skinny plus lets you drag-fill a sequence.