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
101
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).
102
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.
103
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.
104
How can you organize worksheet data to be easier to interpret?
Answer:
All of the above
Formatting, fonts, and styles all improve worksheet readability.
105
To join (concatenate) text in Excel, which symbol should you use?
Answer:
Ampersand (&)
Concatenation is done with the “&” operator.
106
In Excel, how can you make a numeric value appear as text (label) in a cell?
Answer:
By starting with an apostrophe (')
An apostrophe makes numbers display as text labels.
107
What do the tab scrolling buttons in Excel allow you to do?
Answer:
See additional sheets’ tabs
Tab scrolling buttons help you navigate through multiple sheet tabs.
108
What is it called when you use data from a cell in a different worksheet?
Answer:
Referencing
Referring to data on another sheet is known as referencing.
109
What is a worksheet "range" in Excel?
Answer:
A set of cells
A range refers to a group of adjacent or non-adjacent selected cells.
110
In Excel’s Chart Wizard, "data categories" refers to:
Answer:
The horizontal axis
Categories correspond to the values or labels along the X (horizontal) axis.