What is the function of Ctrl + ' in MS Excel?
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “What is the function of Ctrl + ' in MS Excel?”
The accepted answer is B. Copy the formula from the cell above into the active cell. Copy the formula from the cell above into the active cell is the fact required by What is the function of Ctrl ' in MS Excel option B Option A Open the Print Preview window 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 C Expand or collapse the formula bar 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 Open the Format Cells dialog box fall outside the same rule and should be eliminated once Copy the formula from the cell above.
- A. Open the Print Preview window
Why not A: “Open the Print Preview window” is not correct. The accepted answer is B. Copy the formula from the cell above into the active cell. Copy the formula from the cell above into the active cell is the fact required by What is the function of Ctrl ' in MS Excel option B Option A Open the Print Preview window does no
- B. Copy the formula from the cell above into the active cell ✓
- C. Expand or collapse the formula bar
Why not C: “Expand or collapse the formula bar” is not correct. The accepted answer is B. Copy the formula from the cell above into the active cell. Copy the formula from the cell above into the active cell is the fact required by What is the function of Ctrl ' in MS Excel option B Option A Open the Print Preview window does no
- D. Open the Format Cells dialog box
Why not D: “Open the Format Cells dialog box” is not correct. The accepted answer is B. Copy the formula from the cell above into the active cell. Copy the formula from the cell above into the active cell is the fact required by What is the function of Ctrl ' in MS Excel option B Option A Open the Print Preview window does no
Correct answer
B. Copy the formula from the cell above into the active cell
Explanation
Copy the formula from the cell above into the active cell is the fact required by What is the function of Ctrl ' in MS Excel option B Option A Open the Print Preview window 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 C Expand or collapse the formula bar 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 Open the Format Cells dialog box fall outside the same rule and should be eliminated once Copy the formula from the cell above.
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
- Select the correct shortcut key which is used to select the entire worksheet or current data region in MS Exce...
- Which shortcut key is used to create names from row and column labels in MS Excel?
- What does the shortcut key Ctrl + Shift + ^ do in MS Excel?
- Which of the following key combinations allows you to open the Find and Replace dialog box in MS Excel?
- Select the correct shortcut key which is used to start a new line within the same cell in MS Excel.
- What shortcut key combination performs the action to toggle the display of formulas in cells in MS Excel?