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
7221
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.
7222
A function within another function is called a:
Answer:
Nested Function
Nesting functions means using one inside another.
7223
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.
7224
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.
7225
Gridlines:
Answer:
All of the above
Gridline display and printing is fully customizable in Excel.
7226
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.
7227
How is data organized in a spreadsheet?
Answer:
Rows and columns
Spreadsheets rely on a row and column structure.
7228
What types of charts can Excel produce?
Answer:
Bar charts, line graphs, and pie charts
Excel creates various charts, including bar, line, and pie.
7229
Each Excel file is called a workbook because:
Answer:
It can contain multiple sheets—worksheets and chart sheets
Workbooks hold multiple data types in separate sheets.
7230
The Consolidate dialog box is opened from which menu?
Answer:
Data
Use Data > Consolidate to combine data from multiple sheets.