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
81
What is the function of the Ctrl + R shortcut key combination in Microsoft Excel?
Answer:
Fill the selection with active cells to the right
In Microsoft Excel, the Ctrl + R shortcut is the 'Fill Right' command. It copies the contents and formatting of the leftmost cell in a selected range and pastes them into all other cells within that selected range to the right.
82
In Microsoft Excel, what does the appearance of '#########' in a cell signify?
Answer:
The cell needs to be bigger
The '#########' error in Excel occurs when the column width is insufficient to display the entire numerical value or date contained within the cell. Increasing the column width will allow the full content to be visible.
83
In Microsoft Excel, what is the term for a pre-defined formula that uses numbers or symbols to perform standard mathematical calculations?
Answer:
Function
A function in Excel is a built-in, predefined formula that performs specific calculations using provided arguments.
84
Which formatting option should be applied to display monetary values on a chart axis?
Answer:
Currency
To display values as money on a chart axis in Excel, the 'Currency' format is the appropriate choice.
85
What is the name of the component located at the bottom of an Excel workbook window that identifies individual worksheets?
Answer:
Sheet Tab
In Microsoft Excel, the sheet tabs are located at the bottom of the workbook window. These tabs allow users to navigate between different worksheets within the same workbook file, rename them, or change their order.
86
Excel worksheet cells function similarly to which common element found in the Windows graphical user interface?
Answer:
Text boxes
An Excel worksheet cell acts as a container for data entry, much like a text box in a graphical user interface. Both allow users to input, edit, and display alphanumeric characters within a defined boundary.
87
Which of the following is not considered a standard criterion for effective worksheet design?
Answer:
Description
When designing professional spreadsheets, criteria such as efficiency, auditability, and clarity are essential for ensuring the data is accurate, easy to maintain, and simple to interpret.
88
Which Excel function should be used to calculate the sum of cells in a range that meet a specific numerical condition, such as being greater than 1,000?
Answer:
SUMIF
The SUMIF function in Microsoft Excel is designed to sum values in a specified range that meet a single user-defined criterion.
89
An Excel workbook is primarily defined as a collection of which of the following components?
Answer:
Worksheets
An Excel workbook is a file that contains one or more worksheets. While a workbook can contain charts, the fundamental building block that defines the workbook structure is the worksheet itself.
90
How is data structured within a spreadsheet application?
Answer:
Rows and columns
Spreadsheets organize data in a grid format consisting of rows (horizontal) and columns (vertical). The intersection of a row and a column creates a cell, which is the basic unit for storing data in Excel.