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
131
It is acceptable to let text overflow into blank cells when:
Answer:
No data will be entered in the cells next to it
Text will only flow into empty cells.
132
The drag and drop method in Excel is used to:
Answer:
Copy or move cell contents
Drag and drop lets you move or copy cells.
133
Which worksheet element(s) can be protected from changes?
Answer:
All of the above
You can protect contents, objects, and scenarios.
134
What is one way to select a continuous cell range?
Answer:
Drag across the desired cells
Dragging with the mouse selects a range.
135
Which is a valid way to edit cell content?
Answer:
Double-click the cell
Double-clicking allows in-place editing.
136
How do you save a workbook?
Answer:
Click the Save button on the standard toolbar
The Save icon on the toolbar saves your file.
137
In Excel, each cell is referenced by:
Answer:
The cell's row and column labels
Cells are identified by their column (letter) and row (number), like A1, B3, etc.
138
Which constraint prevents duplicate rows in a table?
Answer:
Primary key
The primary key constraint ensures each row is unique.
139
How are data organized in a spreadsheet?
Answer:
Rows and columns
All spreadsheet data is arranged in rows and columns.
140
In Excel, which area is used for entering values and formulas?
Answer:
Formula Bar
You type or edit cell content in the Formula Bar.