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. COUNTIF()

B. AVERAGE()

C. SUMIF()

D. AVERAGEIF()

Answer: Option D

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 MS Word, which of the following is used to create a table of figures?

A. Insert Index

B. Insert Table of Figures

C. Insert Caption

D. Insert Cross-reference

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The Table of Figures feature (under References tab) generates a list of figures based on captions. Captions are inserted for figures, but to generate the table, you use Table of Figures.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, which data type is used for true/false values?

A. Checkbox

B. Yes/No

C. Binary

D. Boolean

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The data type is called Yes/No (stores -1/0 or True/False).

This question belongs to: Computer Microsoft Office

Question #3

In PowerPoint, which presentation view shows only the text of slides in a structured manner?

A. Normal view

B. Slide Sorter view

C. Outline view

D. Notes Page

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Outline view displays slide text in a hierarchical list. In newer PowerPoint, it's a pane in Normal view.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs