Ctrl + Shift + ! is the shortcut key for which of the following actions in MS Excel?
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys question asks: Ctrl + Shift + ! is the shortcut key for which of the following actions in MS Excel? The correct choice is A. Apply the Number format with two decimal places. 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 the Number format with two decimal places ✓
- B. Move to the previous worksheet in the workbook
Why not B: “Move to the previous worksheet in the workbook” does not fit this question. The answer is Apply the Number format with two decimal places.
- C. Copy the formula from the cell above into the active cell
Why not C: “Copy the formula from the cell above into the active cell” does not fit this question. The answer is Apply the Number format with two decimal places.
- D. Open the Create Table dialog box
Why not D: “Open the Create Table dialog box” does not fit this question. The answer is Apply the Number format with two decimal places.
Correct answer
A. Apply the Number format with two decimal places
Explanation
Apply the Number format with two decimal places (option A) is the accepted answer to “Ctrl + Shift + ! is the shortcut key for which of the following actions in MS Excel”. Option B (Move to the previous worksheet in the workbook) does not fit this question. Option C (Copy the formula from the cell above into the active cell) does not fit this question. Option D (Open the Create Table dialog box) does not fit this question. For this MS Excel Shortcut Keys question, the accepted answer is Apply the Number format with two decimal places.
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
- The keyboard shortcut F11 in MS Excel performs which of the following actions?
- Identify the correct shortcut key used to unhide hidden columns within the selection in MS Excel.
- In MS Excel, the shortcut key Ctrl + Shift + _ is used to ________.
- What does the shortcut key Ctrl + F do in MS Excel?
- What is the function of F2 in MS Excel?
- Ctrl + Shift + 0 is the shortcut key for which of the following actions in MS Excel?