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
151
From which menu do you open the Sort dialog box?
Answer:
Data
The Data menu contains the Sort command for arranging data.
152
In Excel 2002, how can you activate the feature that speaks entered data?
Answer:
Point to Speech on the Tools menu, then click Show Text to Speech Toolbar
The Text to Speech toolbar is accessed from the Tools > Speech menu.
153
Which function is used to calculate your monthly mortgage payment?
Answer:
PMT (payments)
The PMT function computes the periodic payment for a loan based on constant payments and a constant interest rate.
154
How can you make Excel convert Deutsche Marks to Euros?
Answer:
On the Tools menu, click Add-Ins, then check Euro Currency Tools
The Euro Currency Tools add-in lets you convert various currencies to Euros.
155
What is a way to print just a selected area of a worksheet if you plan to print a different selection later?
Answer:
All of above
Any of these options allow you to control which area gets printed.
156
What do you call a function placed inside another function?
Answer:
Nested
When you place one function as an argument inside another, it is called a nested function.
157
Which sequence reflects the correct order of operations in Excel formulas?
Answer:
Multiplication and division, positive and negative values, addition and subtraction
The general order is exponentiation first, followed by multiplication/division, then addition/subtraction.
158
How can you print only an embedded chart in Excel?
Answer:
a and b
You can print only the chart by either moving it to its own chart sheet or selecting it before printing.
159
Regarding gridlines in Excel:
Answer:
a, b, and c
Gridlines can be toggled for both display and printing independently.
160
What does the VLOOKUP function do in Excel?
Answer:
Finds related records
VLOOKUP searches for a value in the first column of a table and returns a value from another column in the same row.