In MS Excel, the shortcut key Ctrl + Shift + % is used to ________.
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “In MS Excel, the shortcut key Ctrl + Shift + % is used to ________.”
The accepted answer is A. Apply the Percentage number format. In MS Excel the shortcut key Ctrl Shift is used to is answered by Apply the Percentage number format option A Option B Open the AutoFilter drop-down list does not match the stem it is a near-miss used to catch incomplete recall of Apply the Percentage number format Option C Select the entire worksheet does not match the stem it is a near-miss used to catch incomplete recall of Apply the Percentage number format Remaining alternatives Create an embedded chart of the selected data fall outside the same rule and should be eliminated once Apply the Percentage number format is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations MS Excel Shortcut Keys.
- A. Apply the Percentage number format ✓
- B. Open the AutoFilter drop-down list
Why not B: “Open the AutoFilter drop-down list” is not correct. The accepted answer is A. Apply the Percentage number format. In MS Excel the shortcut key Ctrl Shift is used to is answered by Apply the Percentage number format option A Option B Open the AutoFilter drop-down list does not match the stem it
- C. Select the entire worksheet
Why not C: “Select the entire worksheet” is not correct. The accepted answer is A. Apply the Percentage number format. In MS Excel the shortcut key Ctrl Shift is used to is answered by Apply the Percentage number format option A Option B Open the AutoFilter drop-down list does not match the stem it
- D. Create an embedded chart of the selected data
Why not D: “Create an embedded chart of the selected data” is not correct. The accepted answer is A. Apply the Percentage number format. In MS Excel the shortcut key Ctrl Shift is used to is answered by Apply the Percentage number format option A Option B Open the AutoFilter drop-down list does not match the stem it
Correct answer
A. Apply the Percentage number format
Explanation
In MS Excel the shortcut key Ctrl Shift is used to is answered by Apply the Percentage number format option A Option B Open the AutoFilter drop-down list does not match the stem it is a near-miss used to catch incomplete recall of Apply the Percentage number format Option C Select the entire worksheet does not match the stem it is a near-miss used to catch incomplete recall of Apply the Percentage number format Remaining alternatives Create an embedded chart of the selected data fall outside the same rule and should be eliminated once Apply the Percentage number format is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations MS Excel Shortcut Keys.
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 Ctrl + 2 in MS Excel will ________.
- The keyboard shortcut F5 in MS Excel performs which of the following actions?
- In MS Excel, what is the keyboard shortcut to open the AutoFilter drop-down list?
- Which key combination should be pressed in MS Excel to open the Insert tab on the ribbon?
- Which of the following key combinations allows you to apply the General number format in MS Excel?
- If you want to apply the Percentage number format in MS Excel, which shortcut key will you use?