What is the function of Ctrl + Shift + L in MS Excel?
Difficulty: Medium
About this MCQ
This Medium MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “What is the function of Ctrl + Shift + L in MS Excel?”
The accepted answer is C. Toggle AutoFilter on the selected range. Toggle AutoFilter on the selected range is the fact required by What is the function of Ctrl Shift L in MS Excel option C Option A Hide the selected columns does not match the stem it is a near-miss used to catch incomplete recall of Toggle AutoFilter on the selected range Option B Fill down the content of the cell above does not match the stem it is a near-miss used to catch incomplete recall of Toggle AutoFilter on the selected range Remaining alternatives Create an embedded chart of the selected data fall outside the same rule and should be eliminated once Toggle AutoFilter on the selected range is identified MS Excel Shortcut Keys questions of this type reward precise.
- A. Hide the selected columns
Why not A: “Hide the selected columns” is not correct. The accepted answer is C. Toggle AutoFilter on the selected range. Toggle AutoFilter on the selected range is the fact required by What is the function of Ctrl Shift L in MS Excel option C Option A Hide the selected columns does not match the stem
- B. Fill down the content of the cell above
Why not B: “Fill down the content of the cell above” is not correct. The accepted answer is C. Toggle AutoFilter on the selected range. Toggle AutoFilter on the selected range is the fact required by What is the function of Ctrl Shift L in MS Excel option C Option A Hide the selected columns does not match the stem
- C. Toggle AutoFilter on the selected range ✓
- D. Create an embedded chart of the selected data
Why not D: “Create an embedded chart of the selected data” is not correct. The accepted answer is C. Toggle AutoFilter on the selected range. Toggle AutoFilter on the selected range is the fact required by What is the function of Ctrl Shift L in MS Excel option C Option A Hide the selected columns does not match the stem
Correct answer
C. Toggle AutoFilter on the selected range
Explanation
Toggle AutoFilter on the selected range is the fact required by What is the function of Ctrl Shift L in MS Excel option C Option A Hide the selected columns does not match the stem it is a near-miss used to catch incomplete recall of Toggle AutoFilter on the selected range Option B Fill down the content of the cell above does not match the stem it is a near-miss used to catch incomplete recall of Toggle AutoFilter on the selected range Remaining alternatives Create an embedded chart of the selected data fall outside the same rule and should be eliminated once Toggle AutoFilter on the selected range is identified MS Excel Shortcut Keys questions of this type reward precise.
Source: MS Excel Official Shortcut Key Reference Guide
Tags: Shortcut Keys, Computer MCQs, MS Office, MS Excel, Keyboard Shortcuts
Submitted by: MCQsHub Editorial
Related MCQs
- In MS Excel, what is the keyboard shortcut to create names from row and column labels?
- Which key combination should be pressed in MS Excel to switch between open workbooks?
- Ctrl + 0 is the shortcut key for which of the following actions in MS Excel?
- Pressing F5 in MS Excel will ________.
- Select the correct shortcut key which is used to open the Go To dialog box using the function key shortcut in...
- In MS Excel, the shortcut key Ctrl + 4 is used to ________.