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
161
In spreadsheets, how is data arranged?
Answer:
Rows and columns
Data is systematically arranged in a grid of rows and columns.
162
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.
163
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.
164
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.
165
From which menu are macros executed in Excel?
Answer:
Tools
Macros are created, run, and managed from the Tools menu in Excel's earlier versions.
166
Besides which function, do logical function formulas display "TRUE" or "FALSE" as results?
Answer:
IF
The IF function can return custom values instead of just TRUE or FALSE.
167
If you insert an Excel file into Word, the content is:
Answer:
Embedded
Inserting creates an embedded object, not merely a link.
168
Which function turns row data into column data or vice versa?
Answer:
Transpose
The TRANSPOSE function rearranges data from rows to columns or the other way around.
169
To repeatedly use the Format Painter, you should:
Answer:
Double-click the Format Painter button
Double-clicking the tool lets you apply formatting multiple times.
170
By default, Excel files are saved with which extension?
Answer:
Xls
Excel files use .xls as their standard extension.