Computer Science - IT MCQs
Topic Notes: Computer Science - IT
<p>MCQs and preparation resources for competitive exams, covering important concepts, past papers, and detailed explanations.</p>
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
101
How does an Auto Outlined worksheet differ from a worksheet containing multiple groups?
Answer:
None
In Microsoft Excel, there is no functional difference between an Auto Outlined worksheet and one created with manual grouping.
102
How is a 'Cell Range' defined within a spreadsheet application?
Answer:
a block of cells that can be selected (B4:B16)
A cell range refers to a contiguous group of cells in a spreadsheet, identified by the addresses of the top-left and bottom-right cells, separated by a colon (e.g., B4:B16).
103
Which feature should be enabled to display the specific values associated with each column in a chart?
Answer:
Labels
Data labels are used in charting software to identify the exact value or category represented by a specific bar, slice, or point in a chart.
104
Which mouse pointer icon indicates that the user can move the content of a cell to another location in Excel?
Answer:
Mouse Pointer with anchor at the tip
In Excel, when you hover your mouse over the border of a selected cell or range, the cursor changes into a four-headed arrow or a pointer with an anchor icon.
105
Which of the following Microsoft Excel interface components cannot be toggled on or off by the user?
Answer:
None of above
In Microsoft Excel, the Formula Bar, Status Bar, and various Toolbars (or the Ribbon) are all interface elements that can be customized or toggled visibility through the application's view settings.
106
In spreadsheet software, what is the correct syntax to represent the cell range from G3 to M13?
Answer:
G3:M13
In spreadsheet applications like Microsoft Excel, a colon (:) is used as the range operator to define a continuous block of cells.
107
In the context of spreadsheet software, how is a worksheet range defined?
Answer:
A group of cells
A worksheet range in applications like Microsoft Excel refers to a contiguous block of cells selected together. Ranges are identified by the addresses of the top-left and bottom-right cells, separated by a colon, and are used for formulas and formatting.
108
Which spreadsheet function is used to replace specific text within a string?
Answer:
SUBSTITUTE
The SUBSTITUTE function in spreadsheet applications is designed to replace existing text with new text in a specified string.
109
Which button on the Ribbon interface is used to automatically insert the Sum function for calculating totals in rows or columns?
Answer:
AutoSum
The AutoSum button is a convenient feature located on the Ribbon that automatically detects the range of numerical data in a column or row and inserts the SUM function.
110
How can you configure text within a cell to appear vertically in Microsoft Excel?
Answer:
Choose 90 Degrees in Orientation of Format Cells dialog box
To change text orientation in Excel, you must access the 'Format Cells' dialog box. Within the 'Alignment' tab, there is an 'Orientation' section.