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
2231
Which menu in MS Excel is utilized to remove duplicate values?
Answer:
Data
The 'Remove Duplicates' feature in Microsoft Excel is located on the 'Data' tab of the ribbon, within the 'Data Tools' group. This tool is used to scan a selected range of cells and delete rows that contain duplicate values.
2232
What does the term “filter” refer to in Excel?
Answer:
To temporarily hide certain data based on specific criteria
The Filter feature in Excel allows you to display only the rows that meet certain criteria you specify. It temporarily hides the rows that you do not want to see, making it easier to focus on a specific subset of your data without deleting anything.
2233
What is the shortcut key to insert a chart in Microsoft Excel?
Answer:
Alt+F1
The `Alt+F1` keyboard shortcut in Microsoft Excel provides a quick way to create a chart based on the selected data. It inserts a default chart type (typically a column chart) as an object directly onto the current worksheet.
2234
What is the shortcut key used to create a chart in MS Excel?
Answer:
F11
In Microsoft Excel, the F11 key is a convenient shortcut for creating a chart. When you select a range of data and press F11, Excel automatically creates a new chart sheet with a default chart type (usually a column chart) based on the selected data.
2235
Which symbol initiates an Excel formula?
Answer:
=
In any spreadsheet program, including Microsoft Excel, all formulas and functions must begin with an equal sign (`=`). This symbol tells Excel that the succeeding characters constitute a formula to be calculated, rather than just text or a number to be stored.
2236
What is the primary purpose of the SUM function in Microsoft Excel?
Answer:
To add up a range of cells
The `SUM` function is one of the most fundamental and widely used functions in Microsoft Excel. Its primary purpose is to calculate the total sum by adding all the numbers in a specified range of cells.
2237
Which Excel function removes extra spaces from a text string while keeping single spaces between words?
Answer:
TRIM
The `TRIM` function in Excel is specifically designed to clean up text data. It removes all spaces from a text string except for single spaces between words. It also removes leading and trailing spaces.
2238
What does the VLOOKUP formula do in Excel?
Answer:
VLOOKUP retrieves data based on specified criteria from the leftmost column, searching vertically for a value.
VLOOKUP stands for 'Vertical Lookup'. It is a powerful Excel function that searches for a specific value in the first (leftmost) column of a data table and then returns a corresponding value from a specified column in the same row where the match was found.
2239
Which MS Excel function returns the current date and time?
Answer:
Now()
The `NOW()` function in Microsoft Excel is a volatile function that returns the current system date and time. Whenever the worksheet is recalculated, the value in the cell containing `NOW()` will be updated.
2240
Which keyboard shortcut is used to switch to the next sheet in Microsoft Excel?
Answer:
Ctrl + Page Down
In Microsoft Excel, you can quickly navigate between worksheets in a workbook using keyboard shortcuts. `Ctrl + Page Down` moves to the next sheet to the right, while `Ctrl + Page Up` moves to the previous sheet to the left.