In MS Excel, Ctrl + E is used for which purpose?
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys question asks: In MS Excel, Ctrl + E is used for which purpose? The correct choice is B. Apply Flash Fill to the selected column. Read the options below, commit to one, then use the explanation to see why that choice holds and why the others do not.
MS Excel Shortcut Keys items like this one are written for Pakistan exams such as CSS, FPSC, PPSC, and NTS. The difficulty label is a hint about how much of the topic the stem assumes, not a score. Tags and exam names, when they are present, tell you where else the same idea is tested. Previous and next links stay in MS Excel Shortcut Keys so you can continue the subject. Related questions point at nearby stems if you want another angle on the same idea.
Treat the explanation as part of the question, not a footnote. If you missed it, reread the stem against the correct option before you open the next MS Excel Shortcut Keys item. A timed quiz is the same pool with a clock and a score. A past paper is a full sitting rather than this single question.
- A. Remove the outline border from selected cells
Why not A: “Remove the outline border from selected cells” does not fit this question. The answer is Apply Flash Fill to the selected column.
- B. Apply Flash Fill to the selected column ✓
- C. Apply bold formatting to selected cells
Why not C: “Apply bold formatting to selected cells” does not fit this question. The answer is Apply Flash Fill to the selected column.
- D. Repeat the last action or toggle a cell reference type
Why not D: “Repeat the last action or toggle a cell reference type” does not fit this question. The answer is Apply Flash Fill to the selected column.
Correct answer
B. Apply Flash Fill to the selected column
Explanation
Apply Flash Fill to the selected column (option B) is the accepted answer to “In MS Excel, Ctrl + E is used for which purpose”. Option A (Remove the outline border from selected cells) does not fit this question. Option C (Apply bold formatting to selected cells) does not fit this question. Option D (Repeat the last action or toggle a cell reference type) does not fit this question. For this MS Excel Shortcut Keys question, the accepted answer is Apply Flash Fill to the selected column.
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
- What does the shortcut key Ctrl + O do in MS Excel?
- What does the shortcut key Ctrl + Z do in MS Excel?
- Pressing Ctrl + U in MS Excel will ________.
- Which of the following key combinations allows you to open the Insert tab on the ribbon in MS Excel?
- In MS Excel, the shortcut key Ctrl + Minus is used to ________.
- Which action is performed when you press Ctrl + Shift + % in MS Excel?