What does the shortcut key Shift + F3 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 Shift + F3 do in MS Excel?”
The accepted answer is A. Open the Insert Function dialog box. Open the Insert Function dialog box is the fact required by What does the shortcut key Shift F do in MS Excel option A Option B Open the Insert tab on the ribbon does not match the stem it is a near-miss used to catch incomplete recall of Open the Insert Function dialog box Option C Close the active workbook does not match the stem it is a near-miss used to catch incomplete recall of Open the Insert Function dialog box Remaining alternatives Create names from row and column labels fall outside the same rule and should be eliminated once Open the Insert Function dialog box is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather.
- A. Open the Insert Function dialog box ✓
- B. Open the Insert tab on the ribbon
Why not B: “Open the Insert tab on the ribbon” is not correct. The accepted answer is A. Open the Insert Function dialog box. Open the Insert Function dialog box is the fact required by What does the shortcut key Shift F do in MS Excel option A Option B Open the Insert tab on the ribbon does not match the
- C. Close the active workbook
Why not C: “Close the active workbook” is not correct. The accepted answer is A. Open the Insert Function dialog box. Open the Insert Function dialog box is the fact required by What does the shortcut key Shift F do in MS Excel option A Option B Open the Insert tab on the ribbon does not match the
- D. Create names from row and column labels
Why not D: “Create names from row and column labels” is not correct. The accepted answer is A. Open the Insert Function dialog box. Open the Insert Function dialog box is the fact required by What does the shortcut key Shift F do in MS Excel option A Option B Open the Insert tab on the ribbon does not match the
Correct answer
A. Open the Insert Function dialog box
Explanation
Open the Insert Function dialog box is the fact required by What does the shortcut key Shift F do in MS Excel option A Option B Open the Insert tab on the ribbon does not match the stem it is a near-miss used to catch incomplete recall of Open the Insert Function dialog box Option C Close the active workbook does not match the stem it is a near-miss used to catch incomplete recall of Open the Insert Function dialog box Remaining alternatives Create names from row and column labels fall outside the same rule and should be eliminated once Open the Insert Function dialog box is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather.
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
- In MS Excel, which shortcut key helps you repeat the last action or toggle a cell reference type?
- Select the correct shortcut key which is used to save the active workbook in MS Excel.
- What shortcut key combination performs the action to insert the current date into the active cell in MS Excel?
- What is the function of Ctrl + R in MS Excel?
- The keyboard shortcut Ctrl + T in MS Excel performs which of the following actions?
- In MS Excel, the shortcut key Ctrl + Shift + # is used to ________.