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
7241
To edit existing data in a cell, press:
Answer:
F2
F2 activates in-cell editing mode.
7242
"Qtr 1, Qtr 2, Qtr 3" is an example of a:
Answer:
Series
Sequential labels like “Qtr 1,” “Qtr 2,” etc., are a series.
7243
An expression instructing how numbers in cells are calculated is called:
Answer:
Formula
Formulas dictate calculations and relationships between cell values.
7244
Which Pivot Table toolbar button updates data after source data changes?
Answer:
Refresh Data
Refresh Data updates Pivot Table reports with new values.
7245
The Formula Palette allows you to:
Answer:
Create and edit formulas containing functions
The Formula Palette is a tool for entering and editing formulas.
7246
Keyboard shortcut to create a chart from selected cells:
Answer:
F11
Pressing F11 quickly creates a chart from the selection.
7247
What does AutoFill do?
Answer:
Extends a sequential series
AutoFill fills number, date, or text series automatically.
7248
Which key confirms cell content entry?
Answer:
Enter
Pressing Enter saves your typed value and moves the selection.
7249
To copy cell contents using drag and drop, press the:
Answer:
Shift key
Press and hold Shift while dragging to copy cell contents.
7250
Which is NOT a worksheet design criterion?
Answer:
Description
Standard design criteria include efficiency, clarity, and auditability; description is not one.