Which function in Excel returns the average of cells that meet a given condition? MCQ with Answer and Explanation

Question

Share Report Error

Which function in Excel returns the average of cells that meet a given condition?

A. AVERAGEIF()

B. COUNTIF()

C. SUMIF()

D. AVERAGE()

Answer: Option A

Solution (By JKSSB Mock Tests)

AVERAGEIF averages based on a criterion. AVERAGEIFS for multiple criteria.

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 Excel, which function returns the current date without time?

A. =TODAY()

B. =DATE()

C. =NOW()

D. =CURRENTDATE()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
TODAY() returns the current date (without time). NOW() returns date and time. DATE creates a date from components. CURRENTDATE is not a function.

This question belongs to: Computer Microsoft Office

Question #2

Which view in MS PowerPoint is used to rehearse timings for a slideshow?

A. Reading View

B. Slide Sorter 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 allows the presenter to see notes, preview next slides, and rehearse timings while the audience sees only the slide show. Slide Show View runs the presentation.

This question belongs to: Computer Microsoft Office

Question #3

Which of the following functions in Excel returns the current date and time?

A. =TODAY()

B. =NOW()

C. =TIME()

D. =DATE()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
=NOW() returns the current date and time. =TODAY() returns only current date. =DATE() creates a date from year, month, day. =TIME() creates time.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs