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
6861
Which function shows only the current date in Excel?
Answer:
Today ( )
The Today() function gives the current date alone.
6862
Which function displays the current date and time in Excel?
Answer:
now( )
The now() function shows both the current date and time.
6863
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.
6864
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.
6865
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.
6866
Microsoft Excel is best described as a:
Answer:
Spreadsheet package
Excel is a powerful software designed for working with spreadsheets.
6867
The "Edit, Clear" command cannot be used to:
Answer:
Delete cells
"Edit, Clear" removes content, notes, or formatting, but not the actual cells themselves.
6868
Which of the following is unavailable in the Consolidate dialog in Excel?
Answer:
Pmt
Functions like Average, Max, and Sum are available, but PMT is not present in the Consolidate dialog.
6869
Which function returns the remainder after dividing a number by a divisor in Excel?
Answer:
MODQ
MOD returns the remainder after division.
6870
Which shortcut selects an entire column in Excel?
Answer:
Ctrl + SpaceBar
Pressing Ctrl + SpaceBar highlights the entire column.