What is the function of Ctrl + Space in MS Excel?
Difficulty: Medium
About this MCQ
This Medium MS Excel Shortcut Keys MCQ checks one syllabus fact.
The question is: “What is the function of Ctrl + Space in MS Excel?”
The accepted answer is D. Select the entire column. Select the entire column is the fact required by What is the function of Ctrl Space in MS Excel option D Option A Insert a table for the selected data does not match the stem it is a near-miss used to catch incomplete recall of Select the entire column Option B Open the Find and Replace dialog box does not match the stem it is a near-miss used to catch incomplete recall of Select the entire column Remaining alternatives Open the Go To dialog box fall outside the same rule and should be eliminated once Select the entire column is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations MS Excel Shortcut Keys.
- A. Insert a table for the selected data
Why not A: “Insert a table for the selected data” is not correct. The accepted answer is D. Select the entire column. Select the entire column is the fact required by What is the function of Ctrl Space in MS Excel option D Option A Insert a table for the selected data does not match the stem it is
- B. Open the Find and Replace dialog box
Why not B: “Open the Find and Replace dialog box” is not correct. The accepted answer is D. Select the entire column. Select the entire column is the fact required by What is the function of Ctrl Space in MS Excel option D Option A Insert a table for the selected data does not match the stem it is
- C. Open the Go To dialog box
Why not C: “Open the Go To dialog box” is not correct. The accepted answer is D. Select the entire column. Select the entire column is the fact required by What is the function of Ctrl Space in MS Excel option D Option A Insert a table for the selected data does not match the stem it is
- D. Select the entire column ✓
Correct answer
D. Select the entire column
Explanation
Select the entire column is the fact required by What is the function of Ctrl Space in MS Excel option D Option A Insert a table for the selected data does not match the stem it is a near-miss used to catch incomplete recall of Select the entire column Option B Open the Find and Replace dialog box does not match the stem it is a near-miss used to catch incomplete recall of Select the entire column Remaining alternatives Open the Go To dialog box fall outside the same rule and should be eliminated once Select the entire column is identified MS Excel Shortcut Keys questions of this type reward precise definitions rather than approximate associations MS Excel Shortcut Keys.
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
- Which shortcut key is used to open the Home tab on the ribbon in MS Excel?
- Which of the following key combinations allows you to create names from row and column labels in MS Excel?
- In MS Excel, what is the keyboard shortcut to delete the selected cells, rows, or columns?
- Which shortcut key is used to delete the selected cells, rows, or columns in MS Excel?
- Which of the following key combinations allows you to apply the General number format in MS Excel?
- What does the shortcut key Alt + = do in MS Excel?