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
561
Which method CANNOT be used to enter data in a cell?
Answer:
Pressing the Esc key
The Esc key cancels data entry.
562
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.
563
Which function calculates monthly mortgage payment?
Answer:
PMT
PMT stands for payment, and calculates loan payment amounts.
564
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.
565
If you want to print a selected worksheet area now, and another area later, you should:
Answer:
Go to the File menu, choose Print, then select 'Selection'
"Selection" under printing is the quickest for ad-hoc areas.
566
A function within another function is called a:
Answer:
Nested Function
Nesting functions means using one inside another.
567
Which is the correct order of precedence for calculations in a formula?
Answer:
Multiplication and division, exponentiation, positive and negative values
Exponentiation first, then multiplication/division, then addition/subtraction.
568
You can print only an embedded chart by:
Answer:
Both A and B
Printing a selected embedded chart or moving it to a chart sheet enables printing just that chart.
569
Gridlines:
Answer:
All of the above
Gridline display and printing is fully customizable in Excel.
570
What does the VLOOKUP function do?
Answer:
Finds related records using a vertical lookup
VLOOKUP searches for values in the first column and returns results from another column.