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
111
To effectively visualize data, what must a PivotChart be linked to within a spreadsheet application?
Answer:
PivotTable
A PivotChart in Excel is designed to provide a graphical representation of data summarized in a PivotTable.
112
What is the correct syntax error in the Excel formula '=Average (B9, B12)'?
Answer:
This is a cell range, so it should have a colon : between the cell addresses
In Microsoft Excel, when calculating the average of a range of cells, a colon is used to denote the inclusive range between two cell references.
113
What is the primary function of the COUNTA() formula in Microsoft Excel?
Answer:
counts non-empty cells
The COUNTA function in Excel is designed to count the number of cells in a specified range that are not empty.
114
Which tool button in Microsoft Excel allows users to quickly calculate the sum of a large range of data?
Answer:
Auto sum
The AutoSum feature in Microsoft Excel is a convenient tool that automatically detects a range of numerical data and inserts a SUM formula to calculate the total. It is located in the Home tab and is designed to save time during data analysis.
115
Which ribbon tab in Microsoft Excel contains the tools necessary to add a comment to a specific worksheet cell?
Answer:
Review
In the Microsoft Excel ribbon interface, the 'Review' tab is dedicated to proofing and collaboration tools.
116
What is the most efficient method to create a sequential number series, such as 1 through 20, in Excel?
Answer:
Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows
The Fill Handle is a powerful Excel feature that recognizes patterns. By entering the first two numbers of a sequence and dragging the fill handle, Excel automatically calculates the increment and populates the remaining cells in the selected range.
117
How can you configure a cell to accept only whole numbers within the range of 9 to 99?
Answer:
The Settings tab under the menu Data -> Validation
Data Validation is the specific feature in Excel used to restrict the type of data or the values that users can enter into a cell, including setting numerical range constraints.
118
What is the standard keyboard shortcut to open the 'Find and Replace' dialog box in most Microsoft applications?
Answer:
Ctrl + H
The keyboard shortcut 'Ctrl + H' is the standard command used to trigger the 'Find and Replace' dialog box in Microsoft Office applications like Excel and Word.
119
What is the standard file extension for files created using the Lotus 1-2-3 spreadsheet application?
Answer:
123
Lotus 1-2-3, a popular spreadsheet program in the 1980s and 1990s, primarily utilized the .123 file extension for its saved worksheets.
120
Under what conditions is the 'Fill Across Worksheet' command enabled in Microsoft Excel?
Answer:
When many sheets are selected
The 'Fill Across Worksheets' feature in Excel is designed to copy data or formatting from one sheet to multiple other sheets simultaneously.