Dear readers,
In Competitive exams like Banking and Insurance , questions related to MS Excel shortcut keys are generally asked in Computer section, to test the computer knowledge of the candidates. So here we are providing you a quiz on MS Excel Shortcut keys, which will be helpful in your preparation. Please try to give the correct answer in the comment box, soon we will publish the correct answers.
1. In
MS Excel, what is the shortcut key to “Edit the selected cell”?
(1) F1
(2) F2
(3) F4
(4) F3
(5) F6
2. In
MS Excel, what is the shortcut key to ” Go to a specific cell”?
(1) F3
(2) F7
(3) F5
(4) F11
(5) F9
3. In
MS Excel, what is the shortcut key to “Open the format cells window”?
(1) Alt +1
(2) Ctrl + 3
(3) Ctrl + Shift + 1
(4) Ctrl + 1
(5) Alt + Ctrl + 3
4. In
MS Excel, what is the shortcut key to “Create a chart from selected data”?
(1) F12
(2) F10
(3) F9
(4) F11
(5) F4
5. In
MS Excel, what is the shortcut key to “Enter the current time”?
(1) Ctrl + Shift + >
(2) Alt + Shift + ;
(3) Ctrl + Shift + ;
(4) Alt + Enter
(5) Ctrl + Shift + =
6. In
MS Excel, what is the shortcut key to “Insert new Worksheet”?
(1) Alt + Ctrl + F1
(2) Alt + Shift + F1
(3) Alt + Shift + F11
(4) Alt + Shift + F3
(5) Alt + Shift + F6
7. In
MS Excel, what is the shortcut key to “Create a formula to sum all of the above
cells”?
(1) Alt + =
(2) Ctrl + =
(3) Alt + Shift + =
(4) Ctrl + Shift + =
(5) Alt + Shift + /
8. In
MS Excel, what is the shortcut key to “Strikethrough highlighted selection”?
(1) Ctrl + 4
(2) Ctrl + A
(3) Ctrl + 9
(4) Ctrl + 5
(5) Ctrl + S
9. In
MS Excel, what is the shortcut key to “Switch between open workbooks or windows”?
(1) Alt + F7
(2) Ctrl + F7
(3) Ctrl + F6
(4) Ctrl + f3
(5) Ctrl + F10
10. In
MS Excel, what is the shortcut key to “Select entire row”?
(1) Ctrl + Space
(2) Shift + Space
(3) Ctrl + –
(4) Alt + Space
(5) Alt + Shift
Answers:
Qs 1 (2) Qs 2 (3)
Qs 3 (4) Qs 4 (4) Qs 5 (3)
Qs 6 (2)
Qs 7 (1) Qs 8 (4) Qs 9 (3)
Qs 10 (2)