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
6731
In Excel, how is the selected (active) cell indicated?
Answer:
A dark wide border
The active cell has a dark wide border around it.
6732
How is the currently active cell shown on an Excel sheet?
Answer:
A dark wide border
The active cell is highlighted with a bold border.
6733
To reduce the value in cell C3 by 10%, which formula would you use in cell C1?
Answer:
-C3*.90
Multiplying C3 by 0.90 decreases its value by 10%.
6734
To add the values in cells A1 and A2, what formula would you enter?
Answer:
=A1 + A2
Use =A1 + A2 to sum the contents of cells A1 and A2.
6735
Which symbol is used for multiplication in arithmetic operations in Excel?
Answer:
*
The asterisk symbol (*) denotes multiplication.
6736
The division operator in Excel is represented by:
Answer:
/
The slash (/) is the standard division operator in Excel.
6737
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.
6738
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.
6739
Every formula in Excel begins with which character?
Answer:
=
All formulas in Excel must start with an equals sign (=).
6740
Which symbol represents division in Excel?
Answer:
/
The forward slash (/) is the division symbol in Excel.