What is the function of Ctrl + A in MS Excel?
Difficulty: Easy
About this MCQ
This Easy MS Excel Shortcut Keys question asks: What is the function of Ctrl + A in MS Excel? The correct choice is D. Select the entire worksheet or current data region. 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. Apply Flash Fill to the selected column
Why not A: “Apply Flash Fill to the selected column” does not fit this question. The answer is Select the entire worksheet or current data region.
- B. Expand or collapse the formula bar
Why not B: “Expand or collapse the formula bar” does not fit this question. The answer is Select the entire worksheet or current data region.
- C. Apply italic formatting to selected cells
Why not C: “Apply italic formatting to selected cells” does not fit this question. The answer is Select the entire worksheet or current data region.
- D. Select the entire worksheet or current data region ✓
Correct answer
D. Select the entire worksheet or current data region
Explanation
Select the entire worksheet or current data region is the value that answers “What is the function of Ctrl + A in MS Excel” (option D). Option A (Apply Flash Fill to the selected column) does not fit this question. Option B (Expand or collapse the formula bar) does not fit this question. Option C (Apply italic formatting to selected cells) does not fit this question. For this MS Excel Shortcut Keys question, the accepted answer is Select the entire worksheet or current data region.
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
- Pressing Ctrl + F10 in MS Excel will ________.
- Ctrl + L is the shortcut key for which of the following actions in MS Excel?
- What shortcut key combination performs the action to paste copied or cut content in MS Excel?
- In MS Excel, the shortcut key Ctrl + Shift + : is used to ________.
- Which key combination should be pressed in MS Excel to apply an outline border around selected cells?
- Which key combination should be pressed in MS Excel to apply the Currency number format?