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
121
What is the standard method to automatically adjust the width of a column to fit its contents in Excel?
Answer:
Double click the right border of column
To perform an 'AutoFit' on a column, you should position your mouse cursor over the line separating the column header (the letter) from the next column to the right.
122
If you are currently typing data into an Excel cell and wish to cancel the entry before it is committed, which action should you perform?
Answer:
Press Esc
In Microsoft Excel, pressing the Escape (Esc) key while in the middle of typing into a cell cancels the current entry and reverts the cell to its previous state.
123
What is the standard procedure for inserting a new row into a spreadsheet?
Answer:
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
Inserting a row in spreadsheet software like Microsoft Excel is most commonly achieved by right-clicking the row header and selecting 'Insert' from the context menu. This action shifts existing rows downward to accommodate the new empty row.
124
When designing a PivotTable in Excel, which data components are typically represented as columns?
Answer:
Fields
In the context of Excel PivotTables, the source data is organized into rows and columns.
125
What is the term for software that organizes data into rows and columns?
Answer:
Spreadsheet
A spreadsheet is a software application designed to organize, analyze, and store data in a tabular format consisting of rows and columns.
126
Which logical function does not return 'TRUE' or 'FALSE' as its primary result?
Answer:
IF
While logical functions like AND, OR, and NOT return boolean values, the IF function is a conditional function that returns a user-defined value based on whether a condition is met, rather than just returning TRUE or FALSE.
127
What is the most efficient method to reorder sheet tabs within an Excel workbook?
Answer:
Click and drag the sheet tab to the new location
In Microsoft Excel, the most intuitive and standard way to change the order of worksheets is to click on the specific sheet tab and drag it to the desired position along the tab bar at the bottom of the screen.
128
In Microsoft Excel, which menu contains the option to protect a worksheet?
Answer:
Tools
In older versions of Microsoft Excel, the protection features for worksheets and workbooks were located under the Tools menu.
129
Which chart type should be selected to display vertical rectangles for comparing sales data between two products?
Answer:
Column
A column chart is specifically designed to display data using vertical bars, making it the ideal choice for comparing discrete categories or items, such as sales figures for different products.
130
Which spreadsheet function should be used to display the current date in a specific cell?
Answer:
TODAY
In Microsoft Excel, the TODAY function is specifically designed to return the current date. It updates automatically whenever the worksheet is recalculated.