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
141
In a spreadsheet application, what is the term for a cell that is currently selected and highlighted with a heavy border?
Answer:
Active cell
The active cell is the currently selected cell in a spreadsheet, indicated by a thick border. It is the cell where data entry or formatting commands will be applied when you begin typing or using the interface.
142
Which Excel component is primarily used for summarizing and charting data?
Answer:
worksheet
An Excel worksheet is the primary grid-based environment where users input, organize, and analyze data. It provides the necessary structure for applying mathematical functions, creating pivot tables, and generating charts.
143
Which of the following is not recognized as a standard data type within Microsoft Excel?
Answer:
Character
In Microsoft Excel, data is typically categorized into types such as Numbers, Text (often referred to as Labels), Dates, and Boolean values.
144
Which ribbon tab in Microsoft Excel contains the necessary commands for creating and inserting charts?
Answer:
Insert
In Microsoft Excel, the 'Insert' ribbon tab is the primary location for adding various objects to a worksheet. This includes charts, tables, illustrations, and sparklines.
145
If you accidentally delete a record in a spreadsheet, which command allows you to restore it immediately?
Answer:
Undo
The 'Undo' command is a standard feature in most software applications, including spreadsheet programs like Microsoft Excel.
146
Which feature in spreadsheet software allows you to automatically apply bold formatting to negative values within a selected range?
Answer:
Conditional Formatting
Conditional Formatting is a powerful tool in Excel that changes the appearance of cells based on specific criteria.
147
Which keyboard shortcut is used in Microsoft Excel to apply the currency number format to selected cells?
Answer:
Ctrl+Shift+4
In Microsoft Excel, the keyboard shortcut Ctrl+Shift+4 is the standard command to apply the currency format to the selected cell or range.
148
Which feature is used to provide a visual representation of numerical data?
Answer:
chart
A chart is a graphical tool used to represent data visually.
149
Where can a user modify the calculation mode between automatic and manual in Microsoft Excel?
Answer:
Go to Tools >> Options >> Calculation and mark the corresponding radio button
In older versions of Microsoft Excel, the calculation mode settings were located within the Tools menu under Options.
150
What functionalities are available to a user when operating in Page Break Preview mode in Microsoft Excel?
Answer:
all of above
Page Break Preview is a powerful view in Excel that allows users to visualize how a worksheet will be divided into pages when printed.