In MS Excel, the shortcut key Ctrl + Shift + 9 is used to ________.
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys question asks: In MS Excel, the shortcut key Ctrl + Shift + 9 is used to ________. The correct choice is B. Unhide hidden rows within the selection. 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. Calculate all worksheets in all open workbooks
Why not A: “Calculate all worksheets in all open workbooks” does not fit this question. The answer is Unhide hidden rows within the selection.
- B. Unhide hidden rows within the selection ✓
- C. Close the active workbook
Why not C: “Close the active workbook” does not fit this question. The answer is Unhide hidden rows within the selection.
- D. Repeat the last action or toggle a cell reference type
Why not D: “Repeat the last action or toggle a cell reference type” does not fit this question. The answer is Unhide hidden rows within the selection.
Correct answer
B. Unhide hidden rows within the selection
Explanation
Unhide hidden rows within the selection (option B) is the accepted answer to “In MS Excel, the shortcut key Ctrl + Shift + 9 is used to ________.”. Option A (Calculate all worksheets in all open workbooks) does not fit this question. Option C (Close the active workbook) does not fit this question. Option D (Repeat the last action or toggle a cell reference type) does not fit this question. For this MS Excel Shortcut Keys question, the accepted answer is Unhide hidden rows within the selection.
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
- In MS Excel, which shortcut key helps you apply or remove bold formatting?
- If you want to insert a new worksheet in MS Excel, which shortcut key will you use?
- In MS Excel, which shortcut key helps you insert the AutoSum formula?
- What is the function of Alt + Down Arrow in MS Excel?
- Identify the correct shortcut key used to copy the selected cells or data in MS Excel.
- The keyboard shortcut Ctrl + I in MS Excel performs which of the following actions?