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
6751
To list countries from largest to smallest population, what sort order must be applied?
Answer:
Descending order
Sorting the population field in descending order lists the largest first.
6752
Inserting a blank line after a worksheet title is best done by:
Answer:
Insert a row
The proper way to add a blank line is to insert a whole row.
6753
To preserve the original worksheet and save edited changes to a new file, you should use:
Answer:
Save As
'Save As' creates a new file, leaving the original unchanged.
6754
If you want to record experiment data and create a chart for crystal growth over time, which application should you use?
Answer:
Spreadsheet
Spreadsheets are ideal for recording and graphing experimental data.
6755
What is the most effective way to present monthly rainfall data for Nepal in a report?
Answer:
Chart showing rainfall amounts
A chart best represents variations in rainfall data visually.
6756
NOT, AND, OR, and XOR in Excel are what type of operators?
Answer:
Logical Operators
These operators perform logical operations in Excel formulas.
6757
How does Excel uniquely identify each cell in a worksheet?
Answer:
Column letters and row numbers
Cell addresses are given as column letter + row number (like B5).
6758
What is the purpose of Excel’s Auto Calculate feature?
Answer:
Lets you quickly view results of operations on selected cells
Auto Calculate shows results like sum or average in the status bar for selected cells.
6759
To embed Excel data in a Word document using drag-and-drop, you should:
Answer:
Drag the data to the Word icon on the taskbar while holding Ctrl
Holding Ctrl during drag-and-drop embeds the selected data.
6760
How can you organize worksheet data to be easier to interpret?
Answer:
All of the above
Formatting, fonts, and styles all improve worksheet readability.