In MS Excel, which shortcut key helps you repeat the last action or toggle a cell reference type?
Difficulty: Medium
About this MCQ
This Medium MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “In MS Excel, which shortcut key helps you repeat the last action or toggle a cell reference type?”
The accepted answer is C. F4. “In MS Excel, which shortcut key helps you repeat the last action or toggle a cell reference type” is answered by F4 (option C). Option A (“Ctrl + Shift + Space”) does not match the stem; it is a near-miss used to catch incomplete recall of F4. Option B (“Ctrl + F”) does not match the stem; it is a near-miss used to catch incomplete recall of F4. Remaining alternatives (Shift + Space) fall outside the same rule and should be eliminated once F4 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 + Shift + Space
Why not A: “Ctrl + Shift + Space” is not correct. The accepted answer is C. F4. “In MS Excel, which shortcut key helps you repeat the last action or toggle a cell reference type” is answered by F4 (option C). Option A (“Ctrl + Shift + Space”) does not match th
- B. Ctrl + F
Why not B: “Ctrl + F” is not correct. The accepted answer is C. F4. “In MS Excel, which shortcut key helps you repeat the last action or toggle a cell reference type” is answered by F4 (option C). Option A (“Ctrl + Shift + Space”) does not match th
- C. F4 ✓
- D. Shift + Space
Why not D: “Shift + Space” is not correct. The accepted answer is C. F4. “In MS Excel, which shortcut key helps you repeat the last action or toggle a cell reference type” is answered by F4 (option C). Option A (“Ctrl + Shift + Space”) does not match th
Correct answer
C. F4
Explanation
“In MS Excel, which shortcut key helps you repeat the last action or toggle a cell reference type” is answered by F4 (option C). Option A (“Ctrl + Shift + Space”) does not match the stem; it is a near-miss used to catch incomplete recall of F4. Option B (“Ctrl + F”) does not match the stem; it is a near-miss used to catch incomplete recall of F4. Remaining alternatives (Shift + Space) fall outside the same rule and should be eliminated once F4 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
- The keyboard shortcut Ctrl + T in MS Excel performs which of the following actions?
- What does the shortcut key Shift + F3 do in MS Excel?
- Identify the correct shortcut key used to open the Home tab on the ribbon in MS Excel.
- Which of the following key combinations allows you to save the active workbook in MS Excel?
- Which of the following key combinations allows you to select the entire worksheet in MS Excel?
- Select the correct shortcut key which is used to save the active workbook in MS Excel.