In Excel, the shortcut to create a table (Ctrl+T) will: MCQ with Answer and Explanation

In Excel, the shortcut to create a table (Ctrl+T) will:
A. Sort data
B. Open a new tab
C. Create a chart
D. Convert a range into an Excel table with filters
Answer: Option D
Solution (By JKSSB Mock Tests)
Ctrl+T formats data as a table.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
What is the keyboard shortcut to apply a 1.5 line spacing format to a selected paragraph block in MS Word?
A. Ctrl + 2
B. Ctrl + 1
C. Ctrl + 5
D. Ctrl + Shift + 5

Correct Answer: Option C


Explanation:
In MS Word, the paragraph spacing shortcuts are: Ctrl + 1 for single spacing, Ctrl + 2 for double spacing, and Ctrl + 5 for 1.5 line spacing.

This question belongs to: Computer Microsoft Office
Question #2
In MS Word, which of the following is not a type of indent?
A. Right indent
B. Left indent
C. First line indent
D. Hanging indent

Correct Answer: Option A


Explanation:
Word indents include Left, First line, Hanging, and Right indent is also a type. Actually Right indent exists. So all are types. I'll change to a different question.

This question belongs to: Computer Microsoft Office
Question #3
In Excel, what does the '&' operator do?
A. Performs logical AND
B. Adds numbers
C. Concatenates text strings
D. Raises to power

Correct Answer: Option C


Explanation:
& joins text.

This question belongs to: Computer Microsoft Office