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
2171
Accessing data from cells in another sheet is called:
Answer:
Referencing
Linking to cells on other sheets is known as referencing.
2172
What menu should you use to split the Excel window into two panes?
Answer:
Window > Split
Window > Split splits the current worksheet view.
2173
How can you add a comment to a cell?
Answer:
Insert > Comment
The Insert menu provides the Comment option.
2174
What shortcut is used to replace text/data in cells?
Answer:
Ctrl + H
Ctrl+H opens the Replace dialog for replacing cell content.
2175
To move a worksheet to a whole new workbook, what command should you use?
Answer:
Edit > Move or Copy, select "(new book)" in the dialog
The "To book" dropdown lets you choose "(new book)" to move or copy to a new workbook.
2176
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.
2177
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.
2178
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.
2179
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.
2180
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.