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
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. Aligns cell contents to the left edge
C. Toggles AutoFilter drop-down arrows on or off
D. Locks the selected cell ranges
Answer: Option C
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
In Excel, which function returns the row number of a reference?
A. COLUMN()
B. ROW()
C. ROWS()
D. ROW_NUMBER()
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
ROW(reference) returns row number. COLUMN returns column number.
This question belongs to: Computer Microsoft Office
Question #2
In MS PowerPoint, which option is used to insert a table?
A. Insert > Table
B. Both A and B
C. Insert > Table > Insert Table
D. Home > Table
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
You can insert a table via Insert > Table, then choose a grid or Insert Table dialog. Both are valid.
This question belongs to: Computer Microsoft Office
Question #3
To go to the previous page in a Word document, press:
A. Ctrl + Up Arrow
B. Alt + Page Up
C. Page Up
D. Ctrl + Page Up
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+Page Up moves to the top of the previous page. Page Up scrolls up.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Software 347 Internet and Web Technologies 461 Computer Fundamentals 326 Microsoft Office 1199 CPU (Central Processing Unit) 327
Explore Subjects
Computer 5279 Static General Knowledge 6362 English 15164 Current Affairs 575 History GK 3374
Practice Mix
The difference between simple interest and compound interest on a certain sum of money for 2 years at 9% per annum is Rs. 81. Find the sum.
The process by which plants lose water in the form of liquid droplets is:
The 'Vote on Account' is used to:
Software programs that are custom engineered for banking automated teller machines (ATMs) to connect securely to institutional transaction ledger networks are classified as:
Which is the capital of South Africa (legislative)?