In Excel, what is the shortcut to enter an array formula? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, what is the shortcut to enter an array formula?

A. Ctrl + Shift + Enter

B. Alt + Enter

C. Ctrl + Enter

D. Shift + Enter

Answer: Option A

Solution (By JKSSB Mock Tests)

Array formulas in older Excel require Ctrl+Shift+Enter. In Excel 365, dynamic arrays don't require it, but traditionally it's that.

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 MS Word, the shortcut for 'Select All' is:

A. Ctrl + Shift + A

B. Ctrl + Alt + A

C. Ctrl + A

D. Ctrl + S

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+A selects all.

This question belongs to: Computer Microsoft Office

Question #2

In MS Word, which alignment option spreads text evenly between left and right margins, adding space between words?

A. Centre

B. Distribute

C. Justify

D. Align Left

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Justify (Ctrl+J) aligns text to both margins, adjusting word spacing. Distribute is not a standard paragraph alignment.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, the function =IFERROR(A1/B1, "Error") returns "Error" if:

A. If B1 is zero

B. If A1 is blank

C. Only if #DIV/0!

D. A1/B1 results in any error value

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
IFERROR catches all error types and returns specified value.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs