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
1
Which of the following items is not considered a standard element of the computer spreadsheet interface?
Answer:
Pencil work
A spreadsheet interface consists of components like the workbook, active cell, menu bar, ribbon, and formula bar. 'Pencil work' is a manual task and is not a digital component or interface element within spreadsheet software.
2
What action should be taken when a cell in Microsoft Excel displays a series of hash symbols (#####)?
Answer:
Widen the column
In Microsoft Excel, the ##### error occurs when the column width is insufficient to display the full numeric value or date contained within the cell.
3
Which of the following mathematical operations is not available as an option within the Paste Special dialog box in spreadsheet software?
Answer:
SQRT
The Paste Special dialog box in spreadsheet applications typically includes basic arithmetic operations like Add, Subtract, Multiply, and Divide to modify pasted values. Square root (SQRT) is a function, not a paste operation.
4
Which feature in Microsoft Excel allows you to keep specific rows or columns visible while scrolling through the rest of the worksheet?
Answer:
Freeze Panes
The Freeze Panes feature in Excel is designed to lock specific rows or columns in place. This ensures that headers or labels remain visible on the screen as you scroll through large datasets, improving data readability and navigation efficiency.
5
Which of the following entries is not a valid formula format in Microsoft Excel?
Answer:
10+50
In Microsoft Excel, all formulas must begin with an equals sign (=). An entry like '10+50' without the leading equals sign is treated by Excel as simple text rather than a mathematical instruction, meaning it will not perform the calculation.
6
Which of the following statements is true regarding the display and printing of gridlines in spreadsheet software?
Answer:
a, b and c
Spreadsheet applications like Excel provide flexible controls for gridlines. Users can independently toggle gridlines for the screen display and for the final printed output, allowing for customized document presentation based on specific reporting needs.
7
If a user wants to change the name of a sheet tab in an Excel workbook to represent specific months, which command should be utilized?
Answer:
Rename
To modify the label of a worksheet tab in Microsoft Excel, the user must right-click the tab and select the 'Rename' command.
8
Which process is used in a PivotTable to display only a subset of data that meets specific criteria?
Answer:
Filtering
Filtering is a data analysis feature that allows users to hide rows or columns that do not meet specified criteria. In the context of a PivotTable, it enables the user to focus on a specific segment of the dataset by excluding irrelevant information.
9
What is the most efficient method to select an entire worksheet in Microsoft Excel?
Answer:
Click on the rectangle box on the upper left corner where column headings and row headings meet
In Microsoft Excel, the quickest way to select every cell in the active worksheet is to click the 'Select All' button.
10
What is the requirement for the active cell when inserting a vertical page break in an Excel worksheet?
Answer:
The active cell must be in row 1
To insert a vertical page break in Excel, the active cell must be located in the first row. The page break will be inserted above the selected row, effectively splitting the worksheet horizontally for printing purposes.