Ctrl + ' is the shortcut key for which of the following actions in MS Excel?
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “Ctrl + ' is the shortcut key for which of the following actions in MS Excel?”
The accepted answer is D. Copy the formula from the cell above into the active cell. Ctrl ' is the shortcut key for which of the following actions in MS Excel is answered by Copy the formula from the cell above into the active cell option D Option A Apply or remove italic formatting does not match the stem it is a near-miss used to catch incomplete recall of Copy the formula from the cell above into the active cell Option B Apply the Time number format does not match the stem it is a near-miss used to catch incomplete recall of Copy the formula from the cell above into the active cell Remaining alternatives Insert a table for the selected data fall outside the same rule and should be eliminated once Copy the formula from.
- A. Apply or remove italic formatting
Why not A: “Apply or remove italic formatting” is not correct. The accepted answer is D. Copy the formula from the cell above into the active cell. Ctrl ' is the shortcut key for which of the following actions in MS Excel is answered by Copy the formula from the cell above into the active cell option D Option A Apply or remove
- B. Apply the Time number format
Why not B: “Apply the Time number format” is not correct. The accepted answer is D. Copy the formula from the cell above into the active cell. Ctrl ' is the shortcut key for which of the following actions in MS Excel is answered by Copy the formula from the cell above into the active cell option D Option A Apply or remove
- C. Insert a table for the selected data
Why not C: “Insert a table for the selected data” is not correct. The accepted answer is D. Copy the formula from the cell above into the active cell. Ctrl ' is the shortcut key for which of the following actions in MS Excel is answered by Copy the formula from the cell above into the active cell option D Option A Apply or remove
- D. Copy the formula from the cell above into the active cell ✓
Correct answer
D. Copy the formula from the cell above into the active cell
Explanation
Ctrl ' is the shortcut key for which of the following actions in MS Excel is answered by Copy the formula from the cell above into the active cell option D Option A Apply or remove italic formatting does not match the stem it is a near-miss used to catch incomplete recall of Copy the formula from the cell above into the active cell Option B Apply the Time number format does not match the stem it is a near-miss used to catch incomplete recall of Copy the formula from the cell above into the active cell Remaining alternatives Insert a table for the selected data fall outside the same rule and should be eliminated once Copy the formula from.
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
- Ctrl + W is the shortcut key for which of the following actions in MS Excel?
- In MS Excel, Ctrl + Shift + U is used for which purpose?
- Which of the following key combinations allows you to unhide hidden columns within the selection in MS Excel?
- Which action is performed when you press Ctrl + U in MS Excel?
- In MS Excel, Ctrl + Shift + F3 is used for which purpose?
- If you want to select the entire column in MS Excel, which shortcut key will you use?