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