Computer Science/IT MCQs
Topic Notes: Computer Science/IT
MCQs and preparation resources for competitive exams, covering important concepts, past papers, and detailed explanations.
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
691
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.
692
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.
693
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.
694
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.
695
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.
696
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.
697
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.
698
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.
699
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.
700
Which key is used to select an entire row in Excel?
Answer:
Shift+Space
The `Shift+Space` key combination is the keyboard shortcut used to select the entire row of the currently active cell in Microsoft Excel. This is useful for applying formatting or formulas to an entire row at once.