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
6761
To join (concatenate) text in Excel, which symbol should you use?
Answer:
Ampersand (&)
Concatenation is done with the “&” operator.
6762
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.
6763
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.
6764
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.
6765
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.
6766
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.
6767
In the context of the Chart Wizard, what does the term "data series" mean?
Answer:
A collection of chart data markers
A data series is a group of related data points represented by markers in a chart.
6768
Which item below would NOT be considered a value in Excel terminology?
Answer:
Serial Number 50771
Values in Excel are numbers or dates; “Serial Number 50771” is treated as text because it contains letters.
6769
What is the maximum number of rows in a worksheet?
Answer:
65,535
Older Excel versions support up to 65,535 rows per sheet.
6770
How many characters may be entered in a single cell?
Answer:
65,535
Each cell can contain up to 65,535 characters.