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
2201
Which Excel interface element cannot be turned off?
Answer:
None of above
All these elements can be shown or hidden as needed.
2202
How do you make gridlines appear or disappear in Excel?
Answer:
Both of above
Gridlines can be controlled via Options or specialized toolbars.
2203
Where is calculation mode (auto/manual) changed in Excel?
Answer:
Tools >> Options >> Calculation
Calculation settings are changed under Tools > Options > Calculation tab.
2204
If you want to autofill Nepali months (Baishakh, Jestha, Aashadh, …), which feature do you use?
Answer:
Custom List
Create a custom list for non-default fill series to use with autofill drag.
2205
If Auto Calculate is turned off, how do you manually update formula results?
Answer:
F9
F9 recalculates all formulas in the worksheet.
2206
In Mail Merge involving Excel and Word, Word serves as the:
Answer:
Client
Word acts as the client and Excel as the data source during a mail merge.
2207
Which is NOT a valid way to edit cell content in Excel?
Answer:
Press Alt key
The Alt key does not edit cell content; the other methods do.
2208
What type of sheet is NOT found in an Excel workbook?
Answer:
Data sheet
“Data sheet” is not an Excel sheet type; worksheets, chart sheets, and module sheets are.
2209
What does the Name Box display?
Answer:
Address or name of selected cell/range
The Name box shows the active cell or ranged name.
2210
Where can you find the tab scroll buttons in the Excel window?
Answer:
Bottom left
The sheet tab scroll buttons are at the lower left of the worksheet frame.