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
7291
Which statement about Find and Replace in Excel is NOT true?
Answer:
You can search by sheet, row, or column
You cannot search specifically by row or column; only by sheet or all sheets.
7292
When using Find and Replace, which statement is accurate?
Answer:
Both finding/replacing inside sheet and workbook are possible
Find and replace can be limited to one sheet or the whole workbook.
7293
To permanently remove a sheet from a workbook, what should you do?
Answer:
Edit > Delete Sheet after selecting the sheet
Deleting a sheet is done directly through the Edit menu.
7294
By default, how many worksheets does Excel provide, and what’s the way to delete the extra one?
Answer:
Right-click the third tab and choose Delete
Right-clicking the sheet tab is the typical way to remove a sheet.
7295
How do you only remove formatting in a cell range, leaving values and formulas untouched?
Answer:
Edit menu > Clear > Formats
This command strips out formatting only.
7296
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.
7297
To only clear cell content but leave formatting, use:
Answer:
Edit >> Clear >> Contents
“Clear Contents” removes the content but keeps formatting and comments.
7298
What does Edit >> Delete command do?
Answer:
Deletes entire selected cell(s)
Deletes cells from the worksheet, shifting adjacent cells accordingly.
7299
Which of these mathematical operations is possible in Paste Special?
Answer:
Divide
Paste Special enables operations such as Add, Subtract, Multiply, and Divide.
7300
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.