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
281
The advantage of using a spreadsheet is:
Answer:
All of the above
Spreadsheets automate calculation, update results, and provide flexibility.
282
The correct cell reference for a block starting at B1 to column G, row 10 is:
Answer:
B1:G10
The colon (:) indicates a rectangular range from B1 to G10.
283
You can create hyperlinks from Excel to:
Answer:
All
Excel hyperlinks can point to web pages, other Office files, and more.
284
You can create only a horizontal page break by selecting:
Answer:
A row below where you want the page break
Select the row below the intended break, then insert the break.
285
You can print:
Answer:
All of the above
Excel allows printing of ranges, single, or all worksheets.
286
Pressing F11 to create a chart on a chart sheet gives:
Answer:
A default chart
F11 instantly creates a standard (usually column) chart on its own sheet.
287
On an Excel sheet, the active cell is indicated by:
Answer:
A dark wide border
The currently selected (active) cell has a thick dark outline.
288
To make a number in cell C1 10% smaller than C3, enter:
Answer:
=C3_0.90
Multiplying by 0.90 reduces the value by 10%.
289
To add values in cells A1 and A2, which formula is correct?
Answer:
=A1 + A2
This is the proper way to add two cells in Excel.
290
The multiplication operator is:
Answer:
*
Multiplication is done using the asterisk (*).