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
6671
You can use MS-Excel to automate which of the following?
Answer:
Any of the above
Excel automates a variety of tasks, from accounting to data analysis.
6672
In which area do the Cancel and Enter buttons show up in Excel?
Answer:
Formula bar
When editing a cell, the Cancel and Enter options are displayed on the Formula bar.
6673
The reference B7:B9 refers to:
Answer:
Cells B7 through B9
The notation B7:B9 means all cells from B7 to B9, inclusive.
6674
What type of function is used to calculate depreciation, returns, or loan payments?
Answer:
Financial
Financial functions like PMT, FV, etc., perform such calculations.
6675
Which statement best describes the active cell?
Answer:
Only A and C
The active cell is outlined with a bold border and is the location for entered data.
6676
A .......... is a grid that has labeled columns and rows.
Answer:
Worksheet
A worksheet consists of a grid of columns and rows, where you enter data.
6677
Which tabs are present in Excel's Help menu?
Answer:
All of the above
The help menu in Excel includes Contents, Answer Wizard, and Index tabs.
6678
What is the purpose of the Fill Color button on the Formatting toolbar in Excel?
Answer:
To add shading or color to a cell range
This button applies color to the selected cells.
6679
In Excel, what is meant by a Data Series?
Answer:
A collection of related data
A data series is a sequence of related numbers used in charts and graphs.
6680
What does the small black square in the lower-right corner of an active cell or range represent?
Answer:
Fill handle
The fill handle is used to quickly extend values or formulas to adjacent cells.