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

Question

Share Report Error

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. Aligns cell contents to the left edge

D. Toggles AutoFilter drop-down arrows on or off

Answer: Option D

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.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1

Share Report

What is the maximum number of characters that can be stored in a 'Text' field in MS Access (Short Text)?

A. 1 GB

B. 64,000

C. 255

D. 256

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Short Text field in Access can store up to 255 characters. Long Text can store up to 65,535 characters.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS PowerPoint, what feature allows presenters to use their mobile devices or mouse pointer to highlight slide assets in real-time during a show?

A. Cameo Video Stream integration

B. Laser Pointer

C. Animation Painter tool

D. SmartArt layout indicators

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Holding the Ctrl key and left-clicking during a live slide show turns the mouse cursor into a glowing Laser Pointer to help guide the audience's focus.

This question belongs to: Computer Microsoft Office