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
7351
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.
7352
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.
7353
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.
7354
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.
7355
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.
7356
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.
7357
What is the Excel shortcut to choose a whole column?
Answer:
Ctrl+Space
In Microsoft Excel, pressing `Ctrl+Space` is the keyboard shortcut for selecting the entire column that contains the active cell. This allows for quick formatting or data manipulation of the whole column.
7358
What key combination selects an entire row in Excel?
Answer:
Shift + Space bar
The `Shift + Space bar` is the standard keyboard shortcut in Microsoft Excel to select the entire row containing the currently active cell. This allows for quick selection of all cells in a single row.
7359
_________ is the shortcut key to select the entire column in Excel.
Answer:
Ctrl + Space bar
In Microsoft Excel, the keyboard shortcut to select the entire column of the active cell is `Ctrl + Space bar`. This is a quick way to highlight all cells in a column for formatting or other operations.
7360
Which key is used to edit the selected cell in excel?
Answer:
F2
In Microsoft Excel, pressing the F2 key on a selected cell activates "Edit mode." This places the insertion point inside the cell, allowing you to modify its contents directly without having to retype everything.