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
581
A grainy, non-smooth background appearance is called:
Answer:
Texture
“Texture” refers to a grainy or irregular background.
582
What feature lets you back-solve a cell value for a desired outcome?
Answer:
Goal Seek
Goal Seek finds the right input to get the output you specify.
583
To delete a worksheet from a workbook, you should:
Answer:
Right-click its sheet tab and choose Delete
Right-click and select Delete to remove a worksheet.
584
What is the proper cell reference for a range from B1 to G10?
Answer:
B1:G10
The colon denotes a continuous range from B1 to G10.
585
To edit existing data in a cell, press:
Answer:
F2
F2 activates in-cell editing mode.
586
"Qtr 1, Qtr 2, Qtr 3" is an example of a:
Answer:
Series
Sequential labels like “Qtr 1,” “Qtr 2,” etc., are a series.
587
An expression instructing how numbers in cells are calculated is called:
Answer:
Formula
Formulas dictate calculations and relationships between cell values.
588
Which Pivot Table toolbar button updates data after source data changes?
Answer:
Refresh Data
Refresh Data updates Pivot Table reports with new values.
589
The Formula Palette allows you to:
Answer:
Create and edit formulas containing functions
The Formula Palette is a tool for entering and editing formulas.
590
Keyboard shortcut to create a chart from selected cells:
Answer:
F11
Pressing F11 quickly creates a chart from the selection.