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
81
Which of these are common wildcard characters recognized by Excel?
Answer:
* and ?
The asterisk (*) stands for any number of characters, and the question mark (?) for a single character.
82
Which operator can be used to combine text from two cells into one in Excel?
Answer:
& (ampersand)
The ampersand (&) is used to concatenate or join text from different cells.
83
Every formula in Excel begins with which character?
Answer:
=
All formulas in Excel must start with an equals sign (=).
84
Which symbol represents division in Excel?
Answer:
/
The forward slash (/) is the division symbol in Excel.
85
What symbol is used for multiplication in Excel formulas?
Answer:
*
The asterisk (*) is used to multiply numbers or cell values in Excel.
86
Which one of these is a function in Excel?
Answer:
=SUM(A1:A2)
Functions have names like SUM and use parenthesis with arguments, such as =SUM(A1:A2).
87
Which of these exemplifies a formula in Excel?
Answer:
=A1+A2
Formulas in Excel begin with an equals sign, followed by the calculation like =A1+A2.
88
Which of the following is an example of a cell address?
Answer:
A21
Cell addresses use a column letter followed by a row number, such as A21.
89
How do you distinguish one cell from another in Excel?
Answer:
By its address
Each cell is uniquely identified by a cell address, which combines its column letter and row number.
90
What is the name given to the point where a row crosses a column?
Answer:
A cell
The intersection of a row and a column in a spreadsheet is called a cell.