In Excel, what does the formula =SUMIF(A1:A10, ">5") do? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, what does the formula =SUMIF(A1:A10, ">5") do?

A. Sums all values and adds 5

B. Sums values in A1:A10 that are greater than 5

C. Counts cells greater than 5

D. Returns error

Answer: Option B

Solution (By JKSSB Mock Tests)

SUMIF with criteria ">5" sums cells >5 in the range.

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 PowerPoint, the 'Design Ideas' feature suggests:

A. Slide master edits

B. Professional layouts and design options for slides

C. Animation effects

D. Transition timings

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Design Ideas (Office 365) provides automatic design suggestions.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, which function is used to find the largest value in a range?

A. LARGE

B. MAXIFS

C. MAX

D. MAXA

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The MAX function returns the largest numeric value in a range. LARGE can return the nth largest, MAXA includes logical values, MAXIFS finds max based on criteria.

This question belongs to: Computer Microsoft Office

Question #3

In PowerPoint, the 'Gridlines' option helps to:

A. Draw shapes

B. Create a table

C. Add a chart

D. Align objects precisely on the slide

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Gridlines are non-printing lines for alignment.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs