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
2181
Pressing the Delete key on your keyboard triggers which Excel command?
Answer:
Edit >> Clear >> Contents
“Delete” on the keyboard will only clear what is inside the cell.
2182
To only clear cell content but leave formatting, use:
Answer:
Edit >> Clear >> Contents
“Clear Contents” removes the content but keeps formatting and comments.
2183
What does Edit >> Delete command do?
Answer:
Deletes entire selected cell(s)
Deletes cells from the worksheet, shifting adjacent cells accordingly.
2184
Which of these mathematical operations is possible in Paste Special?
Answer:
Divide
Paste Special enables operations such as Add, Subtract, Multiply, and Divide.
2185
Using Paste Special, which can be pasted selectively?
Answer:
All of above
You can paste only validations, only formats, or only formulas using Paste Special.
2186
Which is not a valid Fill Series type?
Answer:
Time
“Time” is not a direct series type; Linear, Growth, and Autofill are.
2187
When does the Edit >> Fill Across Worksheet command become active?
Answer:
Multiple sheets selected
It only works with more than one worksheet active.
2188
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.
2189
Ctrl + D in Excel does what?
Answer:
Fill down
Ctrl+D quickly copies content from the cell above down into the selected range.
2190
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.