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
461
Where does Excel show the current cell address?
Answer:
Name Box
The Name Box displays the address (e.g., A1) of the active cell.
462
In Excel formulas, which symbol is used to “lock” columns or rows in a cell reference?
Answer:
$
The dollar sign is used for absolute references, fixing columns or rows.
463
Which keyboard shortcut is used to select an entire column?
Answer:
Ctrl+Space Bar
Pressing Ctrl + Spacebar highlights the whole column.
464
What is the function of COUNTA() in Excel?
Answer:
Counts non-empty cells
COUNTA counts all non-empty cells in a range.
465
If you want text in a cell to appear on multiple lines, which option should you use?
Answer:
Format, cells, alignment
Text wrapping is set through the Alignment tab in Format Cells.
466
Which function will display today’s date (without time) in a cell in Excel?
Answer:
today()
The TODAY() function returns only the current date.
467
What function would you use in Excel to insert the current date and time?
Answer:
now()
The NOW() function gives both current date and time.
468
If you apply the format code "#,##0.00" to the value 5436.8, what result will Excel display?
Answer:
5436.80
The format "#,##0.00" displays numbers with two decimal places, so 5436.8 shows as 5436.80.
469
Which types of charts can you create in Excel?
Answer:
All of the above
Excel supports a variety of chart types including Area, Line, Pie, and more.
470
How do you organize data to be in order from smallest to largest or largest to smallest?
Answer:
Data, Sort
The Sort feature in the Data menu arranges your data in ascending or descending order.