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
7201
The Name box is:
Answer:
Left of the formula bar
The Name box is located left of the formula bar and shows the selected cell reference.
7202
Chart tips can:
Answer:
Both B and C
Chart tips (tooltips) can show names of series and values of individual points.
7203
When combining MS Word and Excel, Word is typically the:
Answer:
Client
Word generally acts as the client, retrieving or displaying data from Excel.
7204
To center a worksheet title across a range of cells:
Answer:
Select the range and use the Merge and Center tool
The Merge and Center function merges the cells and centers the text.
7205
To insert three columns between D and E, you should:
Answer:
Select columns E, F, and G
To insert columns, select the columns to the right of where you want them, then insert. Selecting E, F, and G and inserting will put three columns between D and E.
7206
What is a fast way to extend a number sequence (e.g., 1 through 20)?
Answer:
Select both starting cells, then drag the fill handle down 18 more rows
Dragging the fill handle after selecting a pattern quickly continues the sequence.
7207
Which action is NOT a basic step in making a worksheet?
Answer:
Copy the worksheet
Copying is not essential to create a worksheet; entering data, editing, and saving are basic steps.
7208
Paper spreadsheets have all these features except:
Answer:
Speed
Paper spreadsheets cannot offer the calculation and data manipulation speed of electronic spreadsheets.
7209
Which is NOT possible when using Fill Effects in the Format Data Series dialog?
Answer:
Rotate text on the chart
Fill Effects enable patterns, colors, and backgrounds, but do not allow text rotation within a chart via this dialog.
7210
Which method selects all cells in a specific column?
Answer:
Left-click on the gray column header
Clicking the column’s header (such as "A", "B", etc.) highlights every cell in that column.