Correct Answer - Option 1 : Ctrl + shift + L
The correct answer is Ctrl + shift + L.
Ctrl + shift + L is the shortcut to enable filtering of selected cells in MS-Excel.
Shortcuts in Excel:
|
Close a workbook
|
Ctrl+W
|
|
Open a workbook
|
Ctrl+O
|
|
Go to the Home tab
|
Alt+H
|
|
Save a workbook
|
Ctrl+S
|
|
Copy
|
Ctrl+C
|
|
Paste
|
Ctrl+V
|
|
Undo
|
Ctrl+Z
|
|
Remove cell contents
|
Delete
|
|
Choose a fill colour
|
Alt+H, H
|
|
Cut
|
Ctrl+X
|
|
Go to the Insert tab
|
Alt+N
|
|
Bold
|
Ctrl+B
|
|
Center align cell contents
|
Alt+H, A, C
|
|
Go to the Page Layout tab
|
Alt+P
|
|
Go to the Data tab
|
Alt+A
|
|
Go to the View tab
|
Alt+W
|
|
Open context menu
|
Shift+F10, or
Context key
|
|
Add borders
|
Alt+H, B
|
|
Delete column
|
Alt+H, D, C
|
|
Go to the Formula tab
|
Alt+M
|
|
Hide the selected rows
|
Ctrl+9
|
|
Hide the selected columns
|
Ctrl+0
|
