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
201
Where does Excel display the address of the currently active cell?
Answer:
Name Box
The Name Box shows the address or name of the selected cell.
202
Which symbol is used in a formula to make columns or rows absolute?
Answer:
$
The dollar sign $ keeps rows or columns fixed in formulas.
203
Which shortcut highlights the entire column in Excel?
Answer:
Ctrl+SpaceBar
Use Ctrl + SpaceBar to select the current column.
204
How can you wrap text within a cell in Excel?
Answer:
Format cells, alignment
Go to Format → Cells → Alignment to enable text wrapping in a cell.
205
Which function shows only the current date in Excel?
Answer:
Today ( )
The Today() function gives the current date alone.
206
Which function displays the current date and time in Excel?
Answer:
now( )
The now() function shows both the current date and time.
207
If you format the number 5436.8 as '#,##0.00', what will be displayed?
Answer:
5,436.80
This format inserts comma separators and ensures two decimal places.
208
Which type of chart can you create in Excel?
Answer:
All of the above
Excel allows you to create Area, Line, and Pie charts, among others.
209
Which option is used to sort data in ascending or descending order?
Answer:
Data, Sort
The 'Data, Sort' feature organizes data in your chosen order.
210
Microsoft Excel is best described as a:
Answer:
Spreadsheet package
Excel is a powerful software designed for working with spreadsheets.