JUTECH COMPUTER EDUCATION
EXCEL MCQ TYPES QUESTIONS TIME:-25 MINS
ANSWER:WRITE ON PAGE|SEND ME WHATSAPPS NO 9102475303
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
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
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
4. Which Excel shortcut is used to save the current workbook?
a) Ctrl + S
b) Ctrl + N
c) Ctrl + O
d) Ctrl + P
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
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
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
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
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
10. Which Excel shortcut is used to edit the active cell?
a) F1
b) F2
c) F3
d) F4
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
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 + #
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
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 + @
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
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 + #
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
18. Which Excel shortcut is used to repeat the last action?
a) F1
b) F2
c) F3
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
20. Which Excel shortcut is used to close the active workbook?
a) Ctrl + F4
b) Ctrl + S
c) Ctrl + N
d) Ctrl + O
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
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
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
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
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
