What is the function of the keyboard shortcut Ctrl + Shift + Enter in MS Excel? MCQ with Answer and Explanation

Question

Share Report Error

What is the function of the keyboard shortcut Ctrl + Shift + Enter in MS Excel?

A. Executes an Array Formula enclosed in curly braces

B. Forces a text wrap inside a cell

C. Deletes active row entries

D. Inserts a new sheet layout

Answer: Option A

Solution (By JKSSB Mock Tests)

Ctrl + Shift + Enter is the legacy keystroke used to execute array formulas, enclosing the target formula in curly braces { }.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1

In Word, which of the following is used to add a caption to a figure?

A. References > Insert Caption

B. View > Caption

C. Insert > Caption

D. Review > Caption

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Caption is under References.

This question belongs to: Computer Microsoft Office

Question #2

Which view mode should be used in MS PowerPoint to view text content hierarchy and structure exclusively, hiding all images, drawings, and transition animations?

A. Slide Sorter View

B. Outline View

C. Reading View

D. Normal View

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Outline View simplifies the presentation window to show text contents exclusively, letting you review the textual narrative flow clearly.

This question belongs to: Computer Microsoft Office

Question #3

What is the maximum number of rows supported natively by an MS Excel worksheet worksheet file since Excel 2007 (.xlsx onwards)?

A. 65,536

B. 1,048,576

C. 16,384

D. 524,288

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Modern versions of MS Excel support exactly 1,048,576 rows and 16,384 columns per worksheet.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs