What does the shortcut key Ctrl + D do in MS Excel?
Difficulty: Medium
About this MCQ
This Medium MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “What does the shortcut key Ctrl + D do in MS Excel?”
The accepted answer is D. Fill down the content of the cell above. Fill down the content of the cell above is the fact required by What does the shortcut key Ctrl D do in MS Excel option D Option A Expand or collapse the formula bar does not match the stem it is a near-miss used to catch incomplete recall of Fill down the content of the cell above Option B Remove the outline border from selected cells does not match the stem it is a near-miss used to catch incomplete recall of Fill down the content of the cell above Remaining alternatives Create an embedded chart of the selected data fall outside the same rule and should be eliminated once Fill down the content of the cell above is identified MS.
- A. Expand or collapse the formula bar
Why not A: “Expand or collapse the formula bar” is not correct. The accepted answer is D. Fill down the content of the cell above. Fill down the content of the cell above is the fact required by What does the shortcut key Ctrl D do in MS Excel option D Option A Expand or collapse the formula bar does not match
- B. Remove the outline border from selected cells
Why not B: “Remove the outline border from selected cells” is not correct. The accepted answer is D. Fill down the content of the cell above. Fill down the content of the cell above is the fact required by What does the shortcut key Ctrl D do in MS Excel option D Option A Expand or collapse the formula bar does not match
- C. Create an embedded chart of the selected data
Why not C: “Create an embedded chart of the selected data” is not correct. The accepted answer is D. Fill down the content of the cell above. Fill down the content of the cell above is the fact required by What does the shortcut key Ctrl D do in MS Excel option D Option A Expand or collapse the formula bar does not match
- D. Fill down the content of the cell above ✓
Correct answer
D. Fill down the content of the cell above
Explanation
Fill down the content of the cell above is the fact required by What does the shortcut key Ctrl D do in MS Excel option D Option A Expand or collapse the formula bar does not match the stem it is a near-miss used to catch incomplete recall of Fill down the content of the cell above Option B Remove the outline border from selected cells does not match the stem it is a near-miss used to catch incomplete recall of Fill down the content of the cell above Remaining alternatives Create an embedded chart of the selected data fall outside the same rule and should be eliminated once Fill down the content of the cell above is identified MS.
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 + Shift + ~ in MS Excel will ________.
- In MS Excel, what is the keyboard shortcut to insert a hyperlink?
- What shortcut key combination performs the action to select the entire row in MS Excel?
- In MS Excel, Ctrl + Y is used for which purpose?
- Identify the correct shortcut key used to fill all selected cells with the current entry in MS Excel.
- In MS Excel, Ctrl + W is used for which purpose?