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
6791
Which is a valid way to edit cell content?
Answer:
Double-click the cell
Double-clicking allows in-place editing.
6792
How do you save a workbook?
Answer:
Click the Save button on the standard toolbar
The Save icon on the toolbar saves your file.
6793
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.
6794
Which constraint prevents duplicate rows in a table?
Answer:
Primary key
The primary key constraint ensures each row is unique.
6795
How are data organized in a spreadsheet?
Answer:
Rows and columns
All spreadsheet data is arranged in rows and columns.
6796
In Excel, which area is used for entering values and formulas?
Answer:
Formula Bar
You type or edit cell content in the Formula Bar.
6797
Which of these is the latest version of Excel listed?
Answer:
Excel XP
Excel XP (also called Excel 2002) is the most recent among the choices provided.
6798
What shortcut centers a paragraph?
Answer:
CTRL + E
CTRL + E centers the selected text in programs like Excel and Word.
6799
By default, how is text positioned in a cell in Excel?
Answer:
Left-aligned
Normal cell text in Excel is aligned to the left of the cell by default.
6800
Which function is most commonly used by the Subtotals command to display a sum whenever the control field changes?
Answer:
SUM
The SUM function is the standard for subtotal calculations in Excel.