Identify the correct shortcut key used to fill all selected cells with the current entry in MS Excel.
Difficulty: Medium
About this MCQ
This Medium MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “Identify the correct shortcut key used to fill all selected cells with the current entry in MS Excel.”
The accepted answer is C. Ctrl + Enter. “Identify the correct shortcut key used to fill all selected cells with the current entry in MS Excel.” is answered by Ctrl + Enter (option C). Option A (“Ctrl + F”) does not match the stem; it is a near-miss used to catch incomplete recall of Ctrl + Enter. Option B (“Ctrl + D”) does not match the stem; it is a near-miss used to catch incomplete recall of Ctrl + Enter. Remaining alternatives (Ctrl + C) fall outside the same rule and should be eliminated once Ctrl + Enter is identified. MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations. MS Excel Shortcut Keys recall of this distinction is a regular item in FPSC, PPSC, NTS, and CSS papers.
- A. Ctrl + F
Why not A: “Ctrl + F” is not correct. The accepted answer is C. Ctrl + Enter. “Identify the correct shortcut key used to fill all selected cells with the current entry in MS Excel.” is answered by Ctrl + Enter (option C). Option A (“Ctrl + F”) does not match
- B. Ctrl + D
Why not B: “Ctrl + D” is not correct. The accepted answer is C. Ctrl + Enter. “Identify the correct shortcut key used to fill all selected cells with the current entry in MS Excel.” is answered by Ctrl + Enter (option C). Option A (“Ctrl + F”) does not match
- C. Ctrl + Enter ✓
- D. Ctrl + C
Why not D: “Ctrl + C” is not correct. The accepted answer is C. Ctrl + Enter. “Identify the correct shortcut key used to fill all selected cells with the current entry in MS Excel.” is answered by Ctrl + Enter (option C). Option A (“Ctrl + F”) does not match
Correct answer
C. Ctrl + Enter
Explanation
“Identify the correct shortcut key used to fill all selected cells with the current entry in MS Excel.” is answered by Ctrl + Enter (option C). Option A (“Ctrl + F”) does not match the stem; it is a near-miss used to catch incomplete recall of Ctrl + Enter. Option B (“Ctrl + D”) does not match the stem; it is a near-miss used to catch incomplete recall of Ctrl + Enter. Remaining alternatives (Ctrl + C) fall outside the same rule and should be eliminated once Ctrl + Enter is identified. MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations. MS Excel Shortcut Keys recall of this distinction is a regular item in FPSC, PPSC, NTS, and CSS papers.
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
- Ctrl + U is the shortcut key for which of the following actions in MS Excel?
- Pressing Ctrl + Shift + ~ in MS Excel will ________.
- The keyboard shortcut Ctrl + F in MS Excel performs which of the following actions?
- Which key combination should be pressed in MS Excel to fill down the content of the cell above?
- Ctrl + Shift + _ is the shortcut key for which of the following actions in MS Excel?
- What does the shortcut key Ctrl + D do in MS Excel?