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
6951
What is the division operator in Excel?
Answer:
/
The slash (/) is used for division.
6952
What is the operator for multiplication?
Answer:
*
The asterisk (*) is used for multiplication in Excel.
6953
Which is an example of a function?
Answer:
=SUM(A1:A2)
SUM is a function used to add numbers or cell values.
6954
Which is an example of a formula?
Answer:
=A1+A2
Formulas start with “=” and perform calculations using cell references.
6955
Give an example of a cell address.
Answer:
A21
"A21" means column A and row 21, which is a standard cell address.
6956
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.
6957
Where do a row and a column intersect in Excel?
Answer:
A cell
Each intersection of a row and a column creates a cell in a spreadsheet.
6958
When you start typing a value already present in the same column, Excel auto-suggests using:
Answer:
AutoComplete
AutoComplete fills in repetitive entries automatically in a column.
6959
By default, pressing Enter moves cell pointer down. To change this:
Answer:
Tools » Options » Edit tab
The Edit tab allows configuring Enter key behavior.
6960
With Manual Calculation mode ON, which key updates formula values?
Answer:
F9
Pressing F9 recalculates all open workbooks.