What does the shortcut key F4 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 F4 do in MS Excel?”
The accepted answer is B. Repeat the last action or toggle a cell reference type. Repeat the last action or toggle a cell reference type is the fact required by What does the shortcut key F do in MS Excel option B Option A Select the entire worksheet or current data region does not match the stem it is a near-miss used to catch incomplete recall of Repeat the last action or toggle a cell reference type Option C Create an embedded chart of the selected data does not match the stem it is a near-miss used to catch incomplete recall of Repeat the last action or toggle a cell reference type Remaining alternatives Apply the Time number format fall outside the same rule and should be eliminated once Repeat the last action or toggle.
- A. Select the entire worksheet or current data region
Why not A: “Select the entire worksheet or current data region” is not correct. The accepted answer is B. Repeat the last action or toggle a cell reference type. Repeat the last action or toggle a cell reference type is the fact required by What does the shortcut key F do in MS Excel option B Option A Select the entire worksheet or current
- B. Repeat the last action or toggle a cell reference type ✓
- C. Create an embedded chart of the selected data
Why not C: “Create an embedded chart of the selected data” is not correct. The accepted answer is B. Repeat the last action or toggle a cell reference type. Repeat the last action or toggle a cell reference type is the fact required by What does the shortcut key F do in MS Excel option B Option A Select the entire worksheet or current
- D. Apply the Time number format
Why not D: “Apply the Time number format” is not correct. The accepted answer is B. Repeat the last action or toggle a cell reference type. Repeat the last action or toggle a cell reference type is the fact required by What does the shortcut key F do in MS Excel option B Option A Select the entire worksheet or current
Correct answer
B. Repeat the last action or toggle a cell reference type
Explanation
Repeat the last action or toggle a cell reference type is the fact required by What does the shortcut key F do in MS Excel option B Option A Select the entire worksheet or current data region does not match the stem it is a near-miss used to catch incomplete recall of Repeat the last action or toggle a cell reference type Option C Create an embedded chart of the selected data does not match the stem it is a near-miss used to catch incomplete recall of Repeat the last action or toggle a cell reference type Remaining alternatives Apply the Time number format fall outside the same rule and should be eliminated once Repeat the last action or toggle.
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 open the Print Preview window?
- Which shortcut key is used to insert the AutoSum formula in MS Excel?
- Which of the following key combinations allows you to cut the selected cells or data in MS Excel?
- To open the Format Cells dialog box in MS Excel, which key combination should be pressed?
- Which of the following key combinations allows you to apply the Scientific number format in MS Excel?
- Which of the following key combinations allows you to insert the current time into the active cell in MS Excel...