What is the function of the keyboard shortcut Ctrl + Shift + L when working with an active data grid range in MS Excel? MCQ with Answer and Explanation
What is the function of the keyboard shortcut Ctrl + Shift + L when working with an active data grid range in MS Excel?
A. Inserts a bulleted list inside a cell text string
B. Locks the selected cell ranges
C. Toggles AutoFilter drop-down arrows on or off
D. Aligns cell contents to the left edge
Answer: Option C
Solution (By JKExamLibrary)
Ctrl + Shift + L is the native keyboard shortcut to instantly apply or remove the dynamic AutoFilter toggle sorting keys on the active data range headers.
Explanation:
Ctrl + T applies a hanging indent to the selected paragraph. Pressing Ctrl + Shift + T removes or reduces the hanging indent. Ctrl + M applies a standard left indent.
No comments yet. Be the first to start the discussion!