In MS Excel, what is the keyboard shortcut to create a chart of the selected data in a new sheet?
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 create a chart of the selected data in a new sheet?”
The accepted answer is C. F11. “In MS Excel, what is the keyboard shortcut to create a chart of the selected data in a new sheet” is answered by F11 (option C). Option A (“Ctrl + 5”) does not match the stem; it is a near-miss used to catch incomplete recall of F11. Option B (“Shift + F11”) does not match the stem; it is a near-miss used to catch incomplete recall of F11. Remaining alternatives (F5) 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. Ctrl + 5
Why not A: “Ctrl + 5” is not correct. The accepted answer is C. F11. “In MS Excel, what is the keyboard shortcut to create a chart of the selected data in a new sheet” is answered by F11 (option C). Option A (“Ctrl + 5”) does not match the stem; it
- B. Shift + F11
Why not B: “Shift + F11” is not correct. The accepted answer is C. F11. “In MS Excel, what is the keyboard shortcut to create a chart of the selected data in a new sheet” is answered by F11 (option C). Option A (“Ctrl + 5”) does not match the stem; it
- C. F11 ✓
- D. F5
Why not D: “F5” is not correct. The accepted answer is C. F11. “In MS Excel, what is the keyboard shortcut to create a chart of the selected data in a new sheet” is answered by F11 (option C). Option A (“Ctrl + 5”) does not match the stem; it
Correct answer
C. F11
Explanation
“In MS Excel, what is the keyboard shortcut to create a chart of the selected data in a new sheet” is answered by F11 (option C). Option A (“Ctrl + 5”) does not match the stem; it is a near-miss used to catch incomplete recall of F11. Option B (“Shift + F11”) does not match the stem; it is a near-miss used to catch incomplete recall of F11. Remaining alternatives (F5) 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
- In MS Excel, Ctrl + O is used for which purpose?
- Identify the correct shortcut key used to switch between open workbooks in MS Excel.
- The keyboard shortcut Ctrl + Shift + ^ in MS Excel performs which of the following actions?
- Which action is performed when you press F9 in MS Excel?
- Which shortcut key is used to unhide hidden columns within the selection in MS Excel?
- In MS Excel, which shortcut key helps you minimize the active workbook window?