MS Excel Shortcut Keys MCQ Questions and Answers
1. In Excel, to create a new workbook shortcut keys is ?
a) Fn +N
b) Alt +N
c) Ctrl +N
d) Tab +N
2. Open workbooks can easily be switched using ?
a) Alt +S
b) Ctrl +S
c) Ctrl +Alt
d) Ctrl + Tab
3. In Excel, workbook can be closed using___?
a) Esc
b) Ctrl+C
c) Ctrl+E
d) Ctrl+W
4. To create a chart in Excel, Press___?
a) F1
b) F10
c) F11
d) F12
5. In Excel, which shortcut key is used to Open the Save As dialog box ?
a) F2
b) F12
c) Ctrl+S
d) Ctrl+N
6. In Excel, Ctrl+S can be used to ?
a) Save
b) Save As
c) Start New Workbook
d) Switch between opened tab
7. Press to bring up search box ?
a) Shift +F3
b) Shift + F4
c) Shift +F5
d) Shift + F6
8. While selecting multiple worksheets in Excel, the following key must also be used, when clicking the sheet tab ?
a) Alt
b) Tab
c) Ctrl
d) Shift
9. What is the shortcut key to highlight the entire column ?
a) Ctrl+C
b) Ctrl+ Enter
c) Ctrl+ PageUp
d) Ctrl+ Spacebar
10. What is the shortcut key to highlight the entire row ?
a) Shift +C
b) Shift + Enter
c) Shift + Spacebar
d) Shift + PageUp
11. To select all rows and columns in the worksheet, Press___ ?
a) Ctrl +A
b) Ctrl +E
c) Ctrl +T
d) Ctrl +S
12. To minimize the currently selected window, press ?
a) Ctrl+F9
b) Ctrl+ F10
c) Ctrl+ F11
d) Ctrl+ F12
13. To maximize the currently selected window, press ?
a) Ctrl+F9
b) Ctrl+ F10
c) Ctrl+F11
d) Ctrl+ F12
14. To displays the open dialog box, press___?
a) Alt +O
b) Esc +O
c) Ctrl +O
d) Tab +O
15. In excel, which is used to perform undo operation ?
a) Ctrl +C
b) Ctrl +U
c) Ctrl +X
d) Ctrl +Z
16. Which shortcut key opens the Go To dialog box ?
a) F2
b) F5
c) Ctrl + B
d) Ctrl + Shift + B
17. Which shortcut key is used to copy the selected cells in MS Excel ?
a) Ctrl +A
b) Ctrl +B
c) Ctrl +C
d) Ctrl +D
18. To display the Find and Replace dialog box, Press___
a) Alt +F
b) Ctrl +F
c) Tab +F
d) Esc +F
19. Which shortcut key is used to inserts a new worksheet ?
a) Alt + Shift + F1
b) Alt + Shift + F2
c) Alt + Shift + F3
d) Alt + Shift + F4
20. Which creates a chart of the data in the current range ?
a) Ctrl +F1
b) Ctrl +Alt + F1
c) Esc+F1
d) Alt+F1
21. To open the Excel formula window, press____?
a) Shift +F3
b) Shift + F4
c) Shift + F5
d) Shift + F6
22. Which of the following shortcut key can be used to edit the contents of a cell ?
a) F2 Key
b) F12 Key
c) F11 Key
d) F4 Key
23. How do you Repeats the last command or action in Excel ?
a) Ctrl +C
b) Ctrl +R
c) Ctrl +A
d) Ctrl +Y
24. To cut the selected cells, shortcut key is____?
a) Ctrl +B
b) Ctrl +C
c) Ctrl +V
d) Ctrl +X
25. To displays the Print dialog box in MS Excel, press____?
a) Alt+P
b) Esc+P
c) Tab+P
d) Ctrl+P
26. What is the shortcut key to insert a new comment in a cell?
a) F2
b) Alt+F2
c) Ctrl +F2
d) Shift + F2
27. Without using the mouse or arrow keys, what is the shortcut way to access cell A1 in a spreadsheet ?
a) Press Home
b) Press Alt + Home
c) Press Ctrl + Home
d) Press Shift + Home
28. What is the shortcut key to highlight the entire column?
a) Ctrl +C
b) Ctrl + Enter
c) Ctrl + Page Up
d) Ctrl + Space Bar
29. What is the shortcut key to update formula in a table ?
a) F9
b) Alt+F9
c) Ctrl+F9
d) Shift + F9
30. What is the shortcut key to replace a data with another in sheet ?
a) Ctrl+R
b) Ctrl + Shift + R
c) Ctrl+H
d) Ctrl+F
31. What is the shortcut key to hide entire row ?
a) Ctrl +-
b) Ctrl +H
c) Ctrl+R
d) Ctrl +9
32. What is the shortcut key to unhide entire row ?
a) Ctrl + Shift + –
b) Ctrl + Shift + 9
c) Ctrl + Shift +H
d) Ctrl + Shift +R
33. What is the shortcut key to hide entire column ?
a) Ctrl +-
b) Ctrl +0
c) Ctrl +9
d) Ctrl +C