In MS Excel, what is the keyboard shortcut to copy the formula from the cell above into the active cell?
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “In MS Excel, what is the keyboard shortcut to copy the formula from the cell above into the active cell?”
The accepted answer is B. Ctrl + '. “In MS Excel, what is the keyboard shortcut to copy the formula from the cell above into the active cell” is answered by Ctrl + ' (option B). Option A (“Ctrl + O”) does not match the stem; it is a near-miss used to catch incomplete recall of Ctrl + '. Option C (“Ctrl + F2”) does not match the stem; it is a near-miss used to catch incomplete recall of Ctrl + '. Remaining alternatives (F11) fall outside the same rule and should be eliminated once Ctrl + ' 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 + O
Why not A: “Ctrl + O” is not correct. The accepted answer is B. Ctrl + '. “In MS Excel, what is the keyboard shortcut to copy the formula from the cell above into the active cell” is answered by Ctrl + ' (option B). Option A (“Ctrl + O”) does not match t
- B. Ctrl + ' ✓
- C. Ctrl + F2
Why not C: “Ctrl + F2” is not correct. The accepted answer is B. Ctrl + '. “In MS Excel, what is the keyboard shortcut to copy the formula from the cell above into the active cell” is answered by Ctrl + ' (option B). Option A (“Ctrl + O”) does not match t
- D. F11
Why not D: “F11” is not correct. The accepted answer is B. Ctrl + '. “In MS Excel, what is the keyboard shortcut to copy the formula from the cell above into the active cell” is answered by Ctrl + ' (option B). Option A (“Ctrl + O”) does not match t
Correct answer
B. Ctrl + '
Explanation
“In MS Excel, what is the keyboard shortcut to copy the formula from the cell above into the active cell” is answered by Ctrl + ' (option B). Option A (“Ctrl + O”) does not match the stem; it is a near-miss used to catch incomplete recall of Ctrl + '. Option C (“Ctrl + F2”) does not match the stem; it is a near-miss used to catch incomplete recall of Ctrl + '. Remaining alternatives (F11) fall outside the same rule and should be eliminated once Ctrl + ' 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
- Pressing Alt + Enter in MS Excel will ________.
- Which shortcut key is used to fill all selected cells with the current entry in MS Excel?
- Select the correct shortcut key which is used to copy the selected cells or data in MS Excel.
- Which key combination should be pressed in MS Excel to apply an outline border around selected cells?
- Which action is performed when you press Ctrl + Shift + % in MS Excel?
- What shortcut key combination performs the action to paste copied or cut content in MS Excel?