In MS Excel, the shortcut key Ctrl + ' 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 + ' is used to ________.”
The accepted answer is C. Copy the formula from the cell above into the active cell. In MS Excel the shortcut key Ctrl ' is used to is answered by Copy the formula from the cell above into the active cell option C Option A Toggle the display of formulas in cells 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 Hide the selected rows 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 Repeat the last action or toggle a cell reference type fall outside the same rule and should be eliminated once Copy the formula from.
- A. Toggle the display of formulas in cells
Why not A: “Toggle the display of formulas in cells” is not correct. The accepted answer is C. Copy the formula from the cell above into the active cell. In MS Excel the shortcut key Ctrl ' is used to is answered by Copy the formula from the cell above into the active cell option C Option A Toggle the display of formulas in cells do
- B. Hide the selected rows
Why not B: “Hide the selected rows” is not correct. The accepted answer is C. Copy the formula from the cell above into the active cell. In MS Excel the shortcut key Ctrl ' is used to is answered by Copy the formula from the cell above into the active cell option C Option A Toggle the display of formulas in cells do
- C. Copy the formula from the cell above into the active cell ✓
- D. Repeat the last action or toggle a cell reference type
Why not D: “Repeat the last action or toggle a cell reference type” is not correct. The accepted answer is C. Copy the formula from the cell above into the active cell. In MS Excel the shortcut key Ctrl ' is used to is answered by Copy the formula from the cell above into the active cell option C Option A Toggle the display of formulas in cells do
Correct answer
C. Copy the formula from the cell above into the active cell
Explanation
In MS Excel the shortcut key Ctrl ' is used to is answered by Copy the formula from the cell above into the active cell option C Option A Toggle the display of formulas in cells 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 Hide the selected rows 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 Repeat the last action or toggle a cell reference type 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
- Which key combination should be pressed in MS Excel to unhide hidden rows within the selection?
- What does the shortcut key F7 do in MS Excel?
- In MS Excel, the shortcut key Ctrl + ; is used to ________.
- In MS Excel, which shortcut key helps you move to the previous worksheet in the workbook?
- To apply an outline border around selected cells in MS Excel, which key combination should be pressed?
- What shortcut key combination performs the action to insert the current time into the active cell in MS Excel?