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.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1 Report Error
Which file format is used for a macro-enabled Word document?
A. .doc
B. .docm
C. .dotm
D. .docx

Correct Answer: Option B


Explanation:
.docm is macro-enabled document. .docx without macros, .dotm macro-enabled template.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In MS PowerPoint, what is the default keyboard shortcut used to insert a brand-new, blank slide into the active presentation file?
A. Ctrl + S
B. Ctrl + Shift + N
C. Ctrl + M
D. Ctrl + N

Correct Answer: Option C


Explanation:
Ctrl + M inserts a new slide into the active presentation file. Ctrl + N opens a brand-new, blank presentation file window.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
What is the keyboard shortcut to apply a hanging indent to a selected paragraph block in MS Word?
A. Ctrl + M
B. Ctrl + T
C. Ctrl + H
D. Ctrl + Shift + H

Correct Answer: Option B


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.

This question belongs to: Computer Microsoft Office