In Excel, which of the following is the correct syntax for SUMIF? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which of the following is the correct syntax for SUMIF?

A. SUMIF(criteria, range, sum_range)

B. SUMIF(range, sum_range, criteria)

C. SUMIF(criteria, sum_range)

D. SUMIF(range, criteria, [sum_range])

Answer: Option D

Solution (By JKSSB Mock Tests)

SUMIF(range, criteria, [sum_range]) is correct.

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

Share Report

In PowerPoint, which option allows you to apply a custom color to all slide backgrounds at once?

A. View -> Slide Master -> Background Styles

B. Design -> Format Background -> Apply to All

C. Both A and B

D. Home -> Fill Color

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Both methods can set background for all slides: Slide Master or Format Background with Apply to All.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Word, which of the following is not a type of tab stop?

A. Left

B. Center

C. Right

D. Justify

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Word tab stops include Left, Center, Right, Decimal, and Bar. Justify is a text alignment option, not a tab stop.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In PowerPoint, which view allows you to see the presenter's notes while the audience sees only slides?

A. Normal view

B. Notes Page view

C. Presenter View

D. Slide Show view

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Presenter View (available with dual monitors) shows notes and next slide. Notes Page view is for editing notes.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs