Shortcuts and Productivity Tips for MS Excel MCQs

1. Which shortcut key is used to create a new workbook in Excel?
(A) Ctrl + N
(B) Ctrl + W
(C) Ctrl + O
(D) Ctrl + Shift + N

2. Which Excel shortcut is used to quickly edit the active cell?
(A) F1
(B) F2
(C) F4
(D) F7

3. The shortcut key Ctrl + Shift + L is used for:
(A) Launching spell check
(B) Opening the Format dialog box
(C) Locking worksheet
(D) Applying filters to data

4. Which shortcut key combination is used to insert the current date in a cell?
(A) Shift + ;
(B) Ctrl + :
(C) Ctrl + ;
(D) Alt + D

5. What is the function of F4 in Excel?
(A) Repeat the last action
(B) Insert a new sheet
(C) Close Excel
(D) Show formulas

6. Which shortcut key is used to move to the last cell of a worksheet containing data?
(A) Ctrl + Home
(B) Ctrl + End
(C) Ctrl + Shift + End
(D) Alt + End

7. To quickly auto-sum a column of numbers, you use the shortcut:
(A) Ctrl + A
(B) Ctrl + Shift + =
(C) Alt + =
(D) Shift + Alt + =

8. Which shortcut key is used to insert a new worksheet?
(A) Ctrl + W
(B) Ctrl + Shift + N
(C) Alt + F11
(D) Shift + F11

9. The shortcut Ctrl + Spacebar is used for:
(A) Selecting entire row
(B) Selecting entire column
(C) Inserting space in a cell
(D) Removing extra spaces

10. Which Excel shortcut selects the entire worksheet?
(A) Ctrl + A
(B) Ctrl + Shift + A
(C) Ctrl + Alt + A
(D) Ctrl + Enter