Which action is performed when you press Ctrl + 1 in MS Excel?
Difficulty: Medium
About this MCQ
This Medium MS Excel Shortcut Keys question asks: Which action is performed when you press Ctrl + 1 in MS Excel? The correct choice is A. Open the Format Cells dialog box. 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. Open the Format Cells dialog box ✓
- B. Unhide hidden rows within the selection
Why not B: “Unhide hidden rows within the selection” does not fit this question. The answer is Open the Format Cells dialog box.
- C. Toggle AutoFilter on the selected range
Why not C: “Toggle AutoFilter on the selected range” does not fit this question. The answer is Open the Format Cells dialog box.
- D. Open an existing workbook
Why not D: “Open an existing workbook” does not fit this question. The answer is Open the Format Cells dialog box.
Correct answer
A. Open the Format Cells dialog box
Explanation
Open the Format Cells dialog box is the term that matches “Which action is performed when you press Ctrl + 1 in MS Excel” (option A). Option B (Unhide hidden rows within the selection) does not fit this question. Option C (Toggle AutoFilter on the selected range) does not fit this question. Option D (Open an existing workbook) does not fit this question. For this MS Excel Shortcut Keys question, the accepted answer is Open the Format Cells dialog box.
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
- What shortcut key combination performs the action to insert the current date into the active cell in MS Excel?
- Which of the following key combinations allows you to save the active workbook in MS Excel?
- The keyboard shortcut Ctrl + T in MS Excel performs which of the following actions?
- Select the correct shortcut key which is used to save the active workbook in MS Excel.
- Identify the correct shortcut key used to open the Home tab on the ribbon in MS Excel.
- What is the function of Ctrl + R in MS Excel?