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
6811
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.
6812
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.
6813
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.
6814
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.
6815
Regarding gridlines in Excel:
Answer:
a, b, and c
Gridlines can be toggled for both display and printing independently.
6816
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.
6817
In spreadsheets, how is data arranged?
Answer:
Rows and columns
Data is systematically arranged in a grid of rows and columns.
6818
What types of charts can Excel create?
Answer:
Bar charts, line graphs, and pie charts
Excel provides a variety of chart types, including bar, line, and pie charts.
6819
Why is each Excel file called a "workbook"?
Answer:
Because it can hold many sheets, including worksheets and chart sheets
A workbook is named so because it can include multiple types of sheets.
6820
To access the Consolidate dialog box, choose Consolidate from which menu?
Answer:
Data
The Consolidate command is available under the Data menu for combining data from different ranges.