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. Toggles AutoFilter drop-down arrows on or off
C. Aligns cell contents to the left edge
D. Locks the selected cell ranges
Answer: Option B
Solution (By JKSSB Mock Tests)
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.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
Which Access database object contains programming code that automates complex tasks?
A. Module
B. Report
C. Query
D. Macro

Correct Answer: Option A


Explanation:
Modules contain VBA code for advanced automation. Macros are simpler.

This question belongs to: Computer Microsoft Office
Question #2
In MS PowerPoint, which pane displays the text content of slides in an outline format?
A. Notes pane
B. Slides pane
C. Task pane
D. Outline pane

Correct Answer: Option D


Explanation:
The Outline pane (or Outline view) shows the slide text in a hierarchical outline. Slides pane shows thumbnails, Notes pane shows speaker notes.

This question belongs to: Computer Microsoft Office
Question #3
In MS Access, what type of structural relationship is formed between two tables when a unique primary key is linked to a field that is also a primary key in another table?
A. Many-to-Many
B. One-to-Many
C. Self-Referential
D. One-to-One

Correct Answer: Option D


Explanation:
When both linked fields in a database relationship are primary keys or unique indexes, a One-to-One relationship is generated.

This question belongs to: Computer Microsoft Office