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
661
How do you make gridlines appear or disappear in Excel?
Answer:
Both of above
Gridlines can be controlled via Options or specialized toolbars.
662
Where is calculation mode (auto/manual) changed in Excel?
Answer:
Tools >> Options >> Calculation
Calculation settings are changed under Tools > Options > Calculation tab.
663
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.
664
If Auto Calculate is turned off, how do you manually update formula results?
Answer:
F9
F9 recalculates all formulas in the worksheet.
665
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.
666
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.
667
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.
668
What does the Name Box display?
Answer:
Address or name of selected cell/range
The Name box shows the active cell or ranged name.
669
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.
670
What tool centers content by merging more than one cell?
Answer:
Merge and Center button on Formatting toolbar
“Merge and Center” on the toolbar merges selected cells and aligns content centrally.