Pressing F9 in MS Excel will ________.
Difficulty: Hard
About this MCQ
This Hard MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “Pressing F9 in MS Excel will ________.”
The accepted answer is D. Calculate all worksheets in all open workbooks. Pressing F in MS Excel will is answered by Calculate all worksheets in all open workbooks option D Option A Unhide hidden rows within the selection does not match the stem it is a near-miss used to catch incomplete recall of Calculate all worksheets in all open workbooks Option B Cut the selected cells or data does not match the stem it is a near-miss used to catch incomplete recall of Calculate all worksheets in all open workbooks Remaining alternatives Open the Find and Replace dialog box fall outside the same rule and should be eliminated once Calculate all worksheets in all open workbooks is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate.
- A. Unhide hidden rows within the selection
Why not A: “Unhide hidden rows within the selection” is not correct. The accepted answer is D. Calculate all worksheets in all open workbooks. Pressing F in MS Excel will is answered by Calculate all worksheets in all open workbooks option D Option A Unhide hidden rows within the selection does not match the stem it is a
- B. Cut the selected cells or data
Why not B: “Cut the selected cells or data” is not correct. The accepted answer is D. Calculate all worksheets in all open workbooks. Pressing F in MS Excel will is answered by Calculate all worksheets in all open workbooks option D Option A Unhide hidden rows within the selection does not match the stem it is a
- C. Open the Find and Replace dialog box
Why not C: “Open the Find and Replace dialog box” is not correct. The accepted answer is D. Calculate all worksheets in all open workbooks. Pressing F in MS Excel will is answered by Calculate all worksheets in all open workbooks option D Option A Unhide hidden rows within the selection does not match the stem it is a
- D. Calculate all worksheets in all open workbooks ✓
Correct answer
D. Calculate all worksheets in all open workbooks
Explanation
Pressing F in MS Excel will is answered by Calculate all worksheets in all open workbooks option D Option A Unhide hidden rows within the selection does not match the stem it is a near-miss used to catch incomplete recall of Calculate all worksheets in all open workbooks Option B Cut the selected cells or data does not match the stem it is a near-miss used to catch incomplete recall of Calculate all worksheets in all open workbooks Remaining alternatives Open the Find and Replace dialog box fall outside the same rule and should be eliminated once Calculate all worksheets in all open workbooks is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate.
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 + Shift + ! in MS Excel will ________.
- If you want to apply or remove underline formatting in MS Excel, which shortcut key will you use?
- Which action is performed when you press Shift + F11 in MS Excel?
- Select the correct shortcut key which is used to apply the Number format with two decimal places in MS Excel.
- What does the shortcut key Ctrl + E do in MS Excel?
- Which of the following key combinations allows you to calculate all worksheets in all open workbooks in MS Exc...