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
571
How is data organized in a spreadsheet?
Answer:
Rows and columns
Spreadsheets rely on a row and column structure.
572
What types of charts can Excel produce?
Answer:
Bar charts, line graphs, and pie charts
Excel creates various charts, including bar, line, and pie.
573
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.
574
The Consolidate dialog box is opened from which menu?
Answer:
Data
Use Data > Consolidate to combine data from multiple sheets.
575
Macros are run from which menu?
Answer:
Tools
The Tools menu contains the Macros command.
576
Except for which function, logical formulas show "TRUE"/"FALSE"?
Answer:
IF
The IF function can display custom results; the others return TRUE or FALSE.
577
If you insert an Excel file into Word, the data is:
Answer:
Embedded
By default, inserting an Excel file embeds its contents in the Word document.
578
Which function displays rows as columns and vice versa?
Answer:
TRANSPOSE
TRANSPOSE changes rows into columns and columns into rows.
579
To create an interactive web Pivot Table, use which Office Web component?
Answer:
Pivot Table List
Pivot Table List is the web component for interactive Pivot Table functionality.
580
Excel is a:
Answer:
Spreadsheet
Excel is application software for spreadsheet creation and editing.