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
7031
You CANNOT link Excel worksheet data to a Word document:
Answer:
With the copy and paste buttons on the standard toolbar
Simple copy and paste copies data, but does not create a link for dynamic updates.
7032
You can copy data or formulas:
Answer:
All of the above
There are multiple ways to copy and paste in Excel.
7033
Rounding errors can occur:
Answer:
When you show the results of formulas with different decimal places than the calculated results
When displayed precision differs from calculated precision, rounding errors can appear.
7034
Which is the oldest spreadsheet package?
Answer:
VisiCalc
VisiCalc was the first widely available spreadsheet program.
7035
Status indicators are located on the:
Answer:
Formula bar
Status indicators such as Ready, Edit, and Enter appear left of the Formula Bar.
7036
To create a formula, you can use:
Answer:
Value and cell references
Both values and cell addresses can be used in formulas (e.g., =A1+5).
7037
To edit in an embedded Excel worksheet in a Word document:
Answer:
Use the Excel menu bar and toolbars inside the Word application
Double clicking the embedded sheet brings up Excel’s tools inside Word for in-place editing.
7038
To hold row and column titles in place so they remain visible when you scroll in Excel, click the:
Answer:
Freeze Panes command on the Window menu
"Freeze Panes" keeps row and column headers locked, so they don’t scroll with the worksheet.
7039
Where can you enter values and formulas in Excel?
Answer:
Formula bar
The formula bar at the top displays and lets you edit cell contents.
7040
When Excel data is linked to Word:
Answer:
The Word doc contains a reference to the original source application
Linking embeds a reference so changes in Excel reflect in Word.