Identify the correct shortcut key used to create a chart of the selected data in a new sheet in MS Excel.
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “Identify the correct shortcut key used to create a chart of the selected data in a new sheet in MS Excel.”
The accepted answer is D. F11. “Identify the correct shortcut key used to create a chart of the selected data in a new sheet in MS Excel.” is answered by F11 (option D). Option A (“Shift + Space”) does not match the stem; it is a near-miss used to catch incomplete recall of F11. Option B (“Ctrl + Shift + Space”) does not match the stem; it is a near-miss used to catch incomplete recall of F11. Remaining alternatives (F7) fall outside the same rule and should be eliminated once F11 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. Shift + Space
Why not A: “Shift + Space” is not correct. The accepted answer is D. F11. “Identify the correct shortcut key used to create a chart of the selected data in a new sheet in MS Excel.” is answered by F11 (option D). Option A (“Shift + Space”) does not match
- B. Ctrl + Shift + Space
Why not B: “Ctrl + Shift + Space” is not correct. The accepted answer is D. F11. “Identify the correct shortcut key used to create a chart of the selected data in a new sheet in MS Excel.” is answered by F11 (option D). Option A (“Shift + Space”) does not match
- C. F7
Why not C: “F7” is not correct. The accepted answer is D. F11. “Identify the correct shortcut key used to create a chart of the selected data in a new sheet in MS Excel.” is answered by F11 (option D). Option A (“Shift + Space”) does not match
- D. F11 ✓
Correct answer
D. F11
Explanation
“Identify the correct shortcut key used to create a chart of the selected data in a new sheet in MS Excel.” is answered by F11 (option D). Option A (“Shift + Space”) does not match the stem; it is a near-miss used to catch incomplete recall of F11. Option B (“Ctrl + Shift + Space”) does not match the stem; it is a near-miss used to catch incomplete recall of F11. Remaining alternatives (F7) fall outside the same rule and should be eliminated once F11 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
- Select the correct shortcut key which is used to insert the current time into the active cell in MS Excel.
- What does the shortcut key Ctrl + X do in MS Excel?
- The keyboard shortcut Ctrl + H in MS Excel performs which of the following actions?
- In MS Excel, the shortcut key F7 is used to ________.
- The keyboard shortcut Ctrl + Page Down in MS Excel performs which of the following actions?
- Which action is performed when you press Ctrl + B in MS Excel?