41 MS Excel Shortcut Keys MCQs | For All Competitive Exams and Interviews.
In today's fast-paced world, time is of the essence, especially when dealing with spreadsheets and data management. Microsoft Excel, the widely used spreadsheet software, offers a plethora of powerful functions and features to streamline your work. However, knowing the right shortcuts can significantly enhance your productivity. In this article, we will explore some of the most essential and time-saving MS Excel shortcuts that every user should know.
 |
| MS Excel Shortcut Keys MCQs |
List of Shortcut Keys of MS Excel:
Q.1: Which shortcut key is used to apply outline borders?
Ctrl + Shift + 7
Q.2: Which shortcut key is used to remove all borders?
Ctrl + Shift + _ (Underline)
Q.3: Which key is used for strikethrough selection?
Ctrl + 5
Q.4: Which shortcut key is used to add new worksheet?
Shift + F11
Q.5: Which shortcut key is used to change the font size?
Ctrl + Shift + P
Q.6: In Excel which shortcut key is used to hide the selected columns?
Ctrl+0
Q.7: In MS-Excel which shortcut key is used to move at the beginning of the worksheet?
Ctrl+Home
Q.8: Which key is used to select the entire row?
Shift + Spacebar
Q.9: Which shortcut key is used to convert number in time format?
Ctrl + Shift + @
Q.10: Which shortcut key is used format number in date format?
Ctrl + Shift + #
Q.11: Which shortcut key is used to edit a comment?
Shift + F2
Q.12: Which key is used to delete one character from the right?
Delete
Q.13: Which key is used to insert rows or columns?
Ctrl + Shift +
Q.14: Which key is used to select the entire column?
Ctrl + Spacebar
Q.15: Which shortcut key is for auto sum?
Alt + =
Q.16: In Excel which shortcut key is used to hide the selected rows?
Ctrl+9
Q.17: Shortcut key to change the font in MS Excel is?
Ctrl + Shift + F
Q.18: Which shortcut key is used to format number in currency format?
Ctrl + Shift + $
Q.19: Which shortcut key is used to insert new worksheet?
Alt+Shift+F1
Q.20: Which key is used to open help window?
F1
Q.21: Which key is used to go to a specific cell?
F5
Q.22: Which key is used to insert the current time?
Ctrl+Shift+;
Q.23: Which key is used to create chart in MS Excel?
F11
Q.24: Which key is used to paste the selected text from cell?
Ctrl+V
Q.25: Which key is used to check spelling and grammar?
F7
Q.26: In Excel which shortcut key is used to activate tabs?
Alt
Q.27: Which key is used to save as the document?
F12
Q.28: which key is used to undo the last action?
Ctrl+Z
Q.29: Which key is used to run the Thesaurus on selected word?
Shift+F7
Q.30: In MS-Excel which shortcut key is used to open the macro dialog box?
Alt+F8
Q.31: Which key is used to edit the highlighted cell?
F2
Q.32: Short cut to close the currently opened document?
Ctrl+W
Q.33: Which key is used to select all content of a worksheet?
Ctrl+A
Q.34: Which key is used to open the print window?
Ctrl+P
Q.35: In Excel which shortcut key is used to go to the formulas tab?
Alt+M
Q.36: Which key is used to find and replace text?
Ctrl+H
Q.37: In MS-Excel which shortcut key is used to open the page layout tab?
Alt+P
Q.38: Which key is used to bold the highlighted cells?
Ctrl+B
Q.39: Which key is used to cut selected text?
Ctrl+X
Q.40: Which key applies italic effect on highlighted cells?
Ctrl+I
Q.41: Which key is used to insert a hyperlink?
Ctrl+K
Comments
Post a Comment