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
7211
If you need to use functions but don’t see any, how do you open the Insert Function dialog box?
Answer:
Click the Insert menu and then click Function
The standard way to open the Insert Function dialog box is through the Insert menu. Right-clicking or just typing "=" does not directly open this dialog.
7212
What refers to a set of values saved with the workbook?
Answer:
What-if analysis
What-if analysis allows saving specific variable combinations for analysis purposes.
7213
Which page setup option can NOT be set in the Page Setup dialog?
Answer:
Printer selection
Printer selection is done via Print dialog, not Page Setup.
7214
How can you activate a cell?
Answer:
All of above
All these methods place the cursor in the cell.
7215
Which CANNOT be used to edit a cell's content?
Answer:
Pressing the Alt key
Alt is not for editing cell content.
7216
Which of the following will NOT make text italics in a selected cell?
Answer:
Tools - Wizard - Web Form
This menu doesn't affect text formatting.
7217
Which method CANNOT be used to enter data in a cell?
Answer:
Pressing the Esc key
The Esc key cancels data entry.
7218
How can Excel speak data as you enter it?
Answer:
Point to Speech on the Tools menu, then click Show Text to Speech Toolbar
The Text to Speech toolbar reads out spreadsheet entries.
7219
Which function calculates monthly mortgage payment?
Answer:
PMT
PMT stands for payment, and calculates loan payment amounts.
7220
To convert sums from deutsche marks to euros, do:
Answer:
On the Tools menu, click Add-Ins and enable Euro Currency Tools
The Add-In provides euro conversion tools.