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
6741
What symbol is used for multiplication in Excel formulas?
Answer:
*
The asterisk (*) is used to multiply numbers or cell values in Excel.
6742
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).
6743
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.
6744
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.
6745
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.
6746
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.
6747
Which command can be used to instantly restore a record you just deleted in Excel?
Answer:
Undo
Clicking undo immediately recovers a record erased by mistake.
6748
To group all white cats together in your database, you would sort by:
Answer:
Pet Type, then Color
Sorting first by pet type and then by color organizes all white cats together.
6749
The box within a chart that displays the names of each data category is called the:
Answer:
Legend
The legend explains what each color or symbol in the chart represents.
6750
What is required in a spreadsheet to perform calculations?
Answer:
Formula
Calculations in Excel require formulas.