What does the shortcut key F4 do in MS Excel?
Difficulty: Medium
About this MCQ
This Medium MS Excel Shortcut Keys question asks: What does the shortcut key F4 do in MS Excel? The correct choice is B. Repeat the last action or toggle a cell reference type. Read the options below, commit to one, then use the explanation to see why that choice holds and why the others do not.
MS Excel Shortcut Keys items like this one are written for Pakistan exams such as CSS, FPSC, PPSC, and NTS. The difficulty label is a hint about how much of the topic the stem assumes, not a score. Tags and exam names, when they are present, tell you where else the same idea is tested. Previous and next links stay in MS Excel Shortcut Keys so you can continue the subject. Related questions point at nearby stems if you want another angle on the same idea.
Treat the explanation as part of the question, not a footnote. If you missed it, reread the stem against the correct option before you open the next MS Excel Shortcut Keys item. A timed quiz is the same pool with a clock and a score. A past paper is a full sitting rather than this single question.
- A. Select the entire worksheet or current data region
Why not A: “Select the entire worksheet or current data region” does not fit this question. The answer is Repeat the last action or toggle a cell reference type.
- 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” does not fit this question. The answer is Repeat the last action or toggle a cell reference type.
- D. Apply the Time number format
Why not D: “Apply the Time number format” does not fit this question. The answer is Repeat the last action or toggle a cell reference type.
Correct answer
B. Repeat the last action or toggle a cell reference type
Explanation
Repeat the last action or toggle a cell reference type (option B) is the accepted answer to “What does the shortcut key F4 do in MS Excel”. Option A (Select the entire worksheet or current data region) does not fit this question. Option C (Create an embedded chart of the selected data) does not fit this question. Option D (Apply the Time number format) does not fit this question. For this MS Excel Shortcut Keys question, the accepted answer is Repeat the last action or toggle a cell reference type.
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...