Which action is performed when you press Ctrl + 1 in MS Excel?
Difficulty: Medium
About this MCQ
This Medium MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “Which action is performed when you press Ctrl + 1 in MS Excel?”
The accepted answer is A. Open the Format Cells dialog box. Open the Format Cells dialog box is the person body or term that satisfies Which action is performed when you press Ctrl in MS Excel option A Option B Unhide hidden rows within the selection does not match the stem it is a near-miss used to catch incomplete recall of Open the Format Cells dialog box Option C Toggle AutoFilter on the selected range does not match the stem it is a near-miss used to catch incomplete recall of Open the Format Cells dialog box Remaining alternatives Open an existing workbook fall outside the same rule and should be eliminated once Open the Format Cells dialog box is identified MS Excel Shortcut Keys questions of this type reward precise definitions.
- A. Open the Format Cells dialog box ✓
- B. Unhide hidden rows within the selection
Why not B: “Unhide hidden rows within the selection” is not correct. The accepted answer is A. Open the Format Cells dialog box. Open the Format Cells dialog box is the person body or term that satisfies Which action is performed when you press Ctrl in MS Excel option A Option B Unhide hidden rows within the
- C. Toggle AutoFilter on the selected range
Why not C: “Toggle AutoFilter on the selected range” is not correct. The accepted answer is A. Open the Format Cells dialog box. Open the Format Cells dialog box is the person body or term that satisfies Which action is performed when you press Ctrl in MS Excel option A Option B Unhide hidden rows within the
- D. Open an existing workbook
Why not D: “Open an existing workbook” is not correct. The accepted answer is A. Open the Format Cells dialog box. Open the Format Cells dialog box is the person body or term that satisfies Which action is performed when you press Ctrl in MS Excel option A Option B Unhide hidden rows within the
Correct answer
A. Open the Format Cells dialog box
Explanation
Open the Format Cells dialog box is the person body or term that satisfies Which action is performed when you press Ctrl in MS Excel option A Option B Unhide hidden rows within the selection does not match the stem it is a near-miss used to catch incomplete recall of Open the Format Cells dialog box Option C Toggle AutoFilter on the selected range does not match the stem it is a near-miss used to catch incomplete recall of Open the Format Cells dialog box Remaining alternatives Open an existing workbook fall outside the same rule and should be eliminated once Open the Format Cells dialog box is identified MS Excel Shortcut Keys questions of this type reward precise definitions.
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?