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
7231
Macros are run from which menu?
Answer:
Tools
The Tools menu contains the Macros command.
7232
Except for which function, logical formulas show "TRUE"/"FALSE"?
Answer:
IF
The IF function can display custom results; the others return TRUE or FALSE.
7233
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.
7234
Which function displays rows as columns and vice versa?
Answer:
TRANSPOSE
TRANSPOSE changes rows into columns and columns into rows.
7235
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.
7236
Excel is a:
Answer:
Spreadsheet
Excel is application software for spreadsheet creation and editing.
7237
A grainy, non-smooth background appearance is called:
Answer:
Texture
“Texture” refers to a grainy or irregular background.
7238
What feature lets you back-solve a cell value for a desired outcome?
Answer:
Goal Seek
Goal Seek finds the right input to get the output you specify.
7239
To delete a worksheet from a workbook, you should:
Answer:
Right-click its sheet tab and choose Delete
Right-click and select Delete to remove a worksheet.
7240
What is the proper cell reference for a range from B1 to G10?
Answer:
B1:G10
The colon denotes a continuous range from B1 to G10.