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
291
What is the symbol for divide?
Answer:
/
The slash is the division operator.
292
The two common wildcard characters in Excel are:
Answer:
* and ?
Asterisk (*) matches any number of characters, question mark (?) matches any one character.
293
Which operator can combine text from two cells?
Answer:
& (ampersand)
The ampersand (&) operator joins two or more text strings in Excel.
294
All formulas in Excel start with:
Answer:
=
All formulas must begin with the equals sign (=).
295
What is the division operator in Excel?
Answer:
/
The slash (/) is used for division.
296
What is the operator for multiplication?
Answer:
*
The asterisk (*) is used for multiplication in Excel.
297
Which is an example of a function?
Answer:
=SUM(A1:A2)
SUM is a function used to add numbers or cell values.
298
Which is an example of a formula?
Answer:
=A1+A2
Formulas start with “=” and perform calculations using cell references.
299
Give an example of a cell address.
Answer:
A21
"A21" means column A and row 21, which is a standard cell address.
300
How do you distinguish one cell from another?
Answer:
By its address
Each cell has a unique address combining the column letter and row number.