In MS Excel, Ctrl + T is used for which purpose?
Difficulty: Medium
About this MCQ
This Medium MS Excel Shortcut Keys question asks: In MS Excel, Ctrl + T is used for which purpose? The correct choice is C. Insert a table for the selected data. 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. Select the entire worksheet
Why not A: “Select the entire worksheet” does not fit this question. The answer is Insert a table for the selected data.
- B. Unhide hidden columns within the selection
Why not B: “Unhide hidden columns within the selection” does not fit this question. The answer is Insert a table for the selected data.
- C. Insert a table for the selected data ✓
- D. Apply an outline border around selected cells
Why not D: “Apply an outline border around selected cells” does not fit this question. The answer is Insert a table for the selected data.
Correct answer
C. Insert a table for the selected data
Explanation
Insert a table for the selected data (option C) is the accepted answer to “In MS Excel, Ctrl + T is used for which purpose”. Option A (Select the entire worksheet) does not fit this question. Option B (Unhide hidden columns within the selection) does not fit this question. Option D (Apply an outline border around selected cells) does not fit this question. For this MS Excel Shortcut Keys question, the accepted answer is Insert a table for the selected data.
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
- If you want to minimize the active workbook window in MS Excel, which shortcut key will you use?
- In MS Excel, what is the keyboard shortcut to open the Go To dialog box?
- In MS Excel, which shortcut key helps you apply bold formatting to selected cells?
- Select the correct shortcut key which is used to apply bold formatting to selected cells in MS Excel.
- Pressing Ctrl + B in MS Excel will ________.
- Which of the following key combinations allows you to create a new workbook in MS Excel?