30 Excel Shortcuts Quiz Questions and Answers

Excel shortcuts are keyboard combinations or key sequences that perform specific tasks or actions in Microsoft Excel. These shortcuts help users work more efficiently and quickly navigate through Excel’s various features and functions.

Table of content

• Part 1: 30 Excel shortcuts quiz questions & answers
• Part 2: Download Excel shortcuts questions & answers for free
• Part 3: Free online quiz platform – OnlineExamMaker

Part 1: 30 Excel shortcuts quiz questions & answers

1. What does the Excel shortcut “Ctrl + C” do?
a) Close the current workbook
b) Copy selected cells or content
c) Create a new worksheet
d) Cut selected cells or content

Answer: b) Copy selected cells or content

2. Which Excel shortcut is used to paste copied or cut cells or content?
a) Ctrl + V
b) Ctrl + P
c) Ctrl + X
d) Ctrl + Z

Answer: a) Ctrl + V

3. What is the purpose of the Excel shortcut “Ctrl + Z”?
a) Zoom in on the worksheet
b) Create a new workbook
c) Cut selected cells or content
d) Undo the last action

Answer: d) Undo the last action

4. Which Excel shortcut is used to save the current workbook?
a) Ctrl + S
b) Ctrl + N
c) Ctrl + O
d) Ctrl + P

Answer: a) Ctrl + S

5. What does the Excel shortcut “Ctrl + F” do?
a) Open the “Find and Replace” dialog box
b) Open the “Find” dialog box
c) Format the selected cells
d) Insert a new row or column

Answer: b) Open the “Find” dialog box

6. Which Excel shortcut is used to select all cells in the current worksheet?
a) Ctrl + A
b) Ctrl + Shift + L
c) Ctrl + Space
d) Shift + Space

Answer: a) Ctrl + A

7. What is the purpose of the Excel shortcut “Ctrl + Shift + L”?
a) Apply bold formatting to the selected cells
b) Turn on/off filters in the current worksheet
c) Insert a new worksheet
d) Open the “Go To” dialog box

Answer: b) Turn on/off filters in the current worksheet

8. Which Excel shortcut is used to start a new line within a cell?
a) Ctrl + Enter
b) Alt + Enter
c) Shift + Enter
d) Ctrl + Shift + Enter

Answer: b) Alt + Enter

9. What does the Excel shortcut “Ctrl + Tab” do?
a) Switch between open workbooks
b) Move to the next worksheet
c) Open the “Insert” tab on the ribbon
d) Move to the previous worksheet

Answer: a) Switch between open workbooks

10. Which Excel shortcut is used to edit the active cell?
a) F1
b) F2
c) F3
d) F4

Answer: b) F2

11. What is the purpose of the Excel shortcut “Ctrl + Shift + %”?
a) Apply bold formatting to the selected cells
b) Apply percentage formatting to the selected cells
c) Insert a new row or column
d) Apply underline formatting to the selected cells

Answer: b) Apply percentage formatting to the selected cells

12. Which Excel shortcut is used to apply currency formatting to the selected cells?
a) Ctrl + Shift + $
b) Ctrl + Shift + %
c) Ctrl + Shift + @
d) Ctrl + Shift + #

Answer: a) Ctrl + Shift + $

13. What does the Excel shortcut “Ctrl + Page Up” do?
a) Move to the previous worksheet
b) Move to the next worksheet
c) Move to the beginning of the worksheet
d) Move to the end of the worksheet

Answer: a) Move to the previous worksheet

14. Which Excel shortcut is used to apply date formatting to the selected cells?
a) Ctrl + Shift + !
b) Ctrl + Shift + $
c) Ctrl + Shift + #
d) Ctrl + Shift + @

Answer: c) Ctrl + Shift + #

15. What is the purpose of the Excel shortcut “Ctrl + Shift + _”?
a) Insert a new row or column
b) Remove border formatting from the selected cells
c) Apply underline formatting to the selected cells
d) Apply italic formatting to the selected cells

Answer: b) Remove border formatting from the selected cells

Part 2: Download Excel shortcut questions & answers for free

16. Which Excel shortcut is used to apply comma formatting to the selected cells?
a) Ctrl + Shift + $
b) Ctrl + Shift + %
c) Ctrl + Shift + @
d) Ctrl + Shift + #

Answer: c) Ctrl + Shift + @

17. What does the Excel shortcut “Ctrl + Shift + +” do?
a) Insert a new row or column
b) Delete the selected row or column
c) Copy selected cells or content
d) Cut selected cells or content

Answer: a) Insert a new row or column

18. Which Excel shortcut is used to repeat the last action?
a) F1
b) F2
c) F3
d) F4

Answer: d) F4

19. What is the purpose of the Excel shortcut “Ctrl + Shift + (“?
a) Display the “Format Cells” dialog box
b) Hide the selected rows or columns
c) Move to the first cell of the worksheet
d) Select all cells with formulas

Answer: d) Select all cells with formulas

20. Which Excel shortcut is used to close the active workbook?
a) Ctrl + F4
b) Ctrl + S
c) Ctrl + N
d) Ctrl + O

Answer: a) Ctrl + F4

21. What does the Excel shortcut “Ctrl + Shift + &” do?
a) Insert a new row or column
b) Apply bold formatting to the selected cells
c) Apply border formatting to the selected cells
d) Apply currency formatting to the selected cells

Answer: c) Apply border formatting to the selected cells

22. Which Excel shortcut is used to open the “Go To” dialog box?
a) Ctrl + F5
b) Ctrl + Shift + G
c) Ctrl + G
d) Ctrl + Shift + F

Answer: c) Ctrl + G

23. What is the purpose of the Excel shortcut “Ctrl + Shift + (“?
a) Display the “Format Cells” dialog box
b) Hide the selected rows or columns
c) Move to the first cell of the worksheet
d) Select all cells with formulas

Answer: d) Select all cells with formulas

24. Which Excel shortcut is used to open the “Format Cells” dialog box?
a) Ctrl + Shift + 1
b) Ctrl + Shift + 2
c) Ctrl + Shift + 3
d) Ctrl + Shift + 4

Answer: a) Ctrl + Shift + 1

25. What does the Excel shortcut “Ctrl + Shift + $” do?
a) Apply bold formatting to the selected cells
b) Apply percentage formatting to the selected cells
c) Apply currency formatting to the selected cells
d) Apply date formatting to the selected cells

Answer: c) Apply currency formatting to the selected cells

26. Which Excel shortcut is used to hide the selected rows or columns?
a) Ctrl + Shift + (
b) Ctrl + Shift + )
c) Ctrl + 9
d) Ctrl + 0

Answer: b) Ctrl + Shift + )

27. What is the purpose of the Excel shortcut “Ctrl + Shift + _”?
a) Insert a new row or column
b) Remove border formatting from the selected cells
c) Apply underline formatting to the selected cells
d) Apply italic formatting to the selected cells

Answer: b) Remove border formatting from the selected cells

28. Which Excel shortcut is used to display the “Format Cells” dialog box with the Font tab selected?
a) Ctrl + Shift + 1
b) Ctrl + Shift + 2
c) Ctrl + Shift + 3
d) Ctrl + Shift + 4

Answer: b) Ctrl + Shift + 2

29. What does the Excel shortcut “Ctrl + Shift + (” do?
a) Display the “Format Cells” dialog box
b) Hide the selected rows or columns
c) Move to the first cell of the worksheet
d) Select all cells with formulas

Answer: d) Select all cells with formulas

30. Which Excel shortcut is used to display the “Format Cells” dialog box with the Number tab selected?
a) Ctrl + Shift + 1
b) Ctrl + Shift + 2
c) Ctrl + Shift + 3
d) Ctrl + Shift + 4

Answer: c) Ctrl + Shift + 3

Part 3: Free online quiz maker – OnlineExamMaker

With OnlineExamMaker quiz maker, teachers can easily create, customize, and distribute quizzes with just a few clicks. The intuitive interface provides a range of question types, including multiple-choice, true or false, fill in the blank, and open-ended questions, enabling users to make professional assessments that suit their specific needs.