In MS Excel, the shortcut key Ctrl + E is used to ________.
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “In MS Excel, the shortcut key Ctrl + E is used to ________.”
The accepted answer is D. Apply Flash Fill to the selected column. In MS Excel the shortcut key Ctrl E is used to is answered by Apply Flash Fill to the selected column option D Option A Toggle the display of formulas in cells does not match the stem it is a near-miss used to catch incomplete recall of Apply Flash Fill to the selected column Option B Insert a new worksheet does not match the stem it is a near-miss used to catch incomplete recall of Apply Flash Fill to the selected column Remaining alternatives Fill right the content of the leftmost cell fall outside the same rule and should be eliminated once Apply Flash Fill to the selected column is identified MS Excel Shortcut Keys questions of this type reward.
- A. Toggle the display of formulas in cells
Why not A: “Toggle the display of formulas in cells” is not correct. The accepted answer is D. Apply Flash Fill to the selected column. In MS Excel the shortcut key Ctrl E is used to is answered by Apply Flash Fill to the selected column option D Option A Toggle the display of formulas in cells does not match the s
- B. Insert a new worksheet
Why not B: “Insert a new worksheet” is not correct. The accepted answer is D. Apply Flash Fill to the selected column. In MS Excel the shortcut key Ctrl E is used to is answered by Apply Flash Fill to the selected column option D Option A Toggle the display of formulas in cells does not match the s
- C. Fill right the content of the leftmost cell
Why not C: “Fill right the content of the leftmost cell” is not correct. The accepted answer is D. Apply Flash Fill to the selected column. In MS Excel the shortcut key Ctrl E is used to is answered by Apply Flash Fill to the selected column option D Option A Toggle the display of formulas in cells does not match the s
- D. Apply Flash Fill to the selected column ✓
Correct answer
D. Apply Flash Fill to the selected column
Explanation
In MS Excel the shortcut key Ctrl E is used to is answered by Apply Flash Fill to the selected column option D Option A Toggle the display of formulas in cells does not match the stem it is a near-miss used to catch incomplete recall of Apply Flash Fill to the selected column Option B Insert a new worksheet does not match the stem it is a near-miss used to catch incomplete recall of Apply Flash Fill to the selected column Remaining alternatives Fill right the content of the leftmost cell fall outside the same rule and should be eliminated once Apply Flash Fill to the selected column is identified MS Excel Shortcut Keys questions of this type reward.
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
- Select the correct shortcut key which is used to apply Flash Fill to the selected column in MS Excel.
- What is the function of Alt + F1 in MS Excel?
- Select the correct shortcut key which is used to open the Go To dialog box in MS Excel.
- Which action is performed when you press Ctrl + F2 in MS Excel?
- In MS Excel, the shortcut key Ctrl + Space is used to ________.
- Which shortcut key is used to hide the selected columns in MS Excel?