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
411
Which of these cannot be used to edit a cell’s contents?
Answer:
Pressing the Alt key
Alt is not a shortcut for editing cells.
412
Without mouse or arrows, what’s the fastest way to go to cell A1?
Answer:
Press Ctrl + Home
Ctrl + Home jumps directly to A1 from anywhere in the worksheet.
413
To monitor stock market progress daily, use which chart?
Answer:
Line chart
Line graphs are best for tracking changes over time.
414
Which of these is NOT found in the Page Setup dialog box?
Answer:
Page Break Preview
Page Break Preview is a display mode, not a Page Setup dialog box option.
415
Excel worksheet cells are similar to which Windows GUI component?
Answer:
Text boxes
Individual cells operate like single-line text boxes for entering/editing data.
416
Which is NOT a valid data type in Excel?
Answer:
Character
"Character" is not specifically recognized; "Label" is used for text.
417
How can you change worksheet numbers like "1000" to "$1,000.00"?
Answer:
Click the Currency Style button on the formatting toolbar
The Currency button quickly formats numbers as money.
418
The Paste Special command allows you to:
Answer:
Copy only formatting
Paste Special can paste formatting, values, comments, and perform math operations.
419
Which is the correct precedence order for formulas?
Answer:
Multiplication/division, positive/negative, addition/subtraction
Order is typically exponents, then multiply/divide, then add/subtract.
420
All worksheet formulas:
Answer:
Return a formula result
All formulas ultimately produce an output result.