In MS Excel, Ctrl + Shift + F3 is used for which purpose?
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “In MS Excel, Ctrl + Shift + F3 is used for which purpose?”
The accepted answer is A. Create names from row and column labels. In MS Excel Ctrl Shift F is used for which purpose is answered by Create names from row and column labels option A Option B Insert a new worksheet does not match the stem it is a near-miss used to catch incomplete recall of Create names from row and column labels Option C Open the Format Cells dialog box does not match the stem it is a near-miss used to catch incomplete recall of Create names from row and column labels Remaining alternatives Select the entire worksheet or current data region fall outside the same rule and should be eliminated once Create names from row and column labels is identified MS Excel Shortcut Keys questions of this type reward precise.
- A. Create names from row and column labels ✓
- B. Insert a new worksheet
Why not B: “Insert a new worksheet” is not correct. The accepted answer is A. Create names from row and column labels. In MS Excel Ctrl Shift F is used for which purpose is answered by Create names from row and column labels option A Option B Insert a new worksheet does not match the stem it is a n
- C. Open the Format Cells dialog box
Why not C: “Open the Format Cells dialog box” is not correct. The accepted answer is A. Create names from row and column labels. In MS Excel Ctrl Shift F is used for which purpose is answered by Create names from row and column labels option A Option B Insert a new worksheet does not match the stem it is a n
- D. Select the entire worksheet or current data region
Why not D: “Select the entire worksheet or current data region” is not correct. The accepted answer is A. Create names from row and column labels. In MS Excel Ctrl Shift F is used for which purpose is answered by Create names from row and column labels option A Option B Insert a new worksheet does not match the stem it is a n
Correct answer
A. Create names from row and column labels
Explanation
In MS Excel Ctrl Shift F is used for which purpose is answered by Create names from row and column labels option A Option B Insert a new worksheet does not match the stem it is a near-miss used to catch incomplete recall of Create names from row and column labels Option C Open the Format Cells dialog box does not match the stem it is a near-miss used to catch incomplete recall of Create names from row and column labels Remaining alternatives Select the entire worksheet or current data region fall outside the same rule and should be eliminated once Create names from row and column labels is identified MS Excel Shortcut Keys questions of this type reward precise.
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 shortcut key is used to copy the selected cells or data in MS Excel?
- Ctrl + W is the shortcut key for which of the following actions in MS Excel?
- The keyboard shortcut Ctrl + Page Up in MS Excel performs which of the following actions?
- What is the function of Ctrl + Shift + : in MS Excel?
- Which shortcut key is used to hide the selected rows in MS Excel?
- Ctrl + ' is the shortcut key for which of the following actions in MS Excel?