In Excel, which function is used to calculate the average of a set of numbers but ignores zero values? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which function is used to calculate the average of a set of numbers but ignores zero values?

A. MEDIAN

B. AVERAGEIF

C. AVERAGE

D. AVERAGEA

Answer: Option B

Solution (By JKSSB Mock Tests)

AVERAGEIF can exclude zero by using criteria 0. AVERAGE includes zeros, AVERAGEA includes logicals, MEDIAN is middle value.

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 MS Access, a query that modifies data in a table (like increasing price by 10%) is called:

A. Select query

B. Append query

C. Crosstab query

D. Update query

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Update query changes existing field values.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

What is the shortcut to align selected text to the right margin in MS Word?

A. Ctrl + L

B. Ctrl + E

C. Ctrl + J

D. Ctrl + R

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + R aligns right. Ctrl + L left, Ctrl + E centre, Ctrl + J justify.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

Which of the following is the correct keyboard shortcut to open the 'Format Cells' dialog in Excel?

A. Both A and B

B. Ctrl + 1

C. Ctrl + 2

D. Ctrl + Shift + F

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Both open Format Cells, but Ctrl+1 opens main, Ctrl+Shift+F opens Font tab.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs