Select the correct shortcut key which is used to copy the formula from the cell above into the active cell in MS Excel.
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “Select the correct shortcut key which is used to copy the formula from the cell above into the active cell in MS Excel.”
The accepted answer is D. Ctrl + '. Select the correct shortcut key which is used to copy the formula from the cell above into the active cell in MS Excel is answered by Ctrl ' option D Option A Ctrl Shift does not match the stem it is a near-miss used to catch incomplete recall of Ctrl ' Option B Ctrl D does not match the stem it is a near-miss used to catch incomplete recall of Ctrl ' Remaining alternatives Ctrl 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.
- A. Ctrl + Shift + &
Why not A: “Ctrl + Shift + &” is not correct. The accepted answer is D. Ctrl + '. Select the correct shortcut key which is used to copy the formula from the cell above into the active cell in MS Excel is answered by Ctrl ' option D Option A Ctrl Shift does not m
- B. Ctrl + D
Why not B: “Ctrl + D” is not correct. The accepted answer is D. Ctrl + '. Select the correct shortcut key which is used to copy the formula from the cell above into the active cell in MS Excel is answered by Ctrl ' option D Option A Ctrl Shift does not m
- C. Ctrl + 9
Why not C: “Ctrl + 9” is not correct. The accepted answer is D. Ctrl + '. Select the correct shortcut key which is used to copy the formula from the cell above into the active cell in MS Excel is answered by Ctrl ' option D Option A Ctrl Shift does not m
- D. Ctrl + ' ✓
Correct answer
D. Ctrl + '
Explanation
Select the correct shortcut key which is used to copy the formula from the cell above into the active cell in MS Excel is answered by Ctrl ' option D Option A Ctrl Shift does not match the stem it is a near-miss used to catch incomplete recall of Ctrl ' Option B Ctrl D does not match the stem it is a near-miss used to catch incomplete recall of Ctrl ' Remaining alternatives Ctrl 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.
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 + B do in MS Excel?
- What does the shortcut key Ctrl + Shift + $ do in MS Excel?
- Ctrl + F is the shortcut key for which of the following actions in MS Excel?
- What shortcut key combination performs the action to create a new workbook in MS Excel?
- Identify the correct shortcut key used to create an embedded chart of the selected data in MS Excel.
- To open the Go To dialog box using the function key shortcut in MS Excel, which key combination should be pres...