The most repeated MS Excel MCQs and essential shortcut keys from past competitive exams for effective computer mcq tests preparation online.
Basic Shortcut keys of ms excel
Input Command | Action in MS Excel Sheet |
---|---|
F1 | Opens the Help menu |
F2 | Edit the selected cell |
F4 | Repeat the last action |
F5 | Find a specific cell |
F7 | Spell checker for text |
F11 | Create a chart |
F12 | Save as Option |
Ctrl + D | Fill down the cell in selection |
Ctrl + H | Find and Replace |
Ctrl + K | Insert Hyperlinks |
Ctrl + P | Print the Excel Sheet |
Ctrl + S | Save the Sheet |
Ctrl + W | Close the open Workbook |
Ctrl + Y | Repeat the last done action |
Ctrl + Z | Undo the last done action |
Ctrl + 0 | Hide Selected Columns |
Ctrl + 9 | Hide Selected Rows |
Ctrl + Shift + ( | Unhide the rows |
Ctrl + Shift + ) | Unhide the Columns |
Alt + Shift + F1 | Insert new worksheet |
Shift + F3 | Open the formula box |
Shift + F5 | Open the search box |
Ctrl + F9 | Minimize current window |
Ctrl + F10 | Maximize the selected window |
Ctrl + F6 | Switch between open workbooks |
Ctrl + Tab | Move between open Excel® files |
Ctrl + Shift + ; | Enter the current time |
Ctrl + ; | Enter the current date |
Ctrl + Spacebar | Selects the entire column |
Shift + F2 | Edit a cell comment |
Alt + F4 | Exit from Excel |
Basic MS Excel MCQs
MS Excel stands for_______
- Micromax Excel
- Microsoft Excel
- Micromax Excess
- Management Excel
- All of these
A cell is defined as :
- The intersection of a column and a row
- An input box
- a rectangular marker
- All of the above
Which of the following is not valid zoom percentage in Excel:
- 500%
- 600%
- 700
- None of the above
In which software slide have?
- Word
- PowerPoint
- Excel
- None
What is used to split long text in excel within the cell?
- Wrap text
- Click next
- All
- None
Which of the following methods can not be used to edit the contents of a cell?
- Double clicking the cell
- Press the Alt key
- Pressing the F2 key
- Clicking the formula bar
Which of the following is not a word processor?
- Word Perfect
- Microsoft Excel
- Word Star
- Microsoft Word
To drag a selected range of data to another worksheet in the same workbook, use the?
- Shift key
- Alt key
- Tab key
- Ctrl key
When a range is selected, how can you activate the previous?
- Press Tab
- Press the Alt key
- Press Enter
- none
Tab scroll buttons are place on excel screen
- Towards the bottom left corner
- Towards the bottom right corner
- Towards the bottom top right corner
- None