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. AVERAGEIF

B. AVERAGE

C. AVERAGEA

D. MEDIAN

Answer: Option A

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

Which specialized view or wizard tool in MS Excel displays a step-by-step breakdown of calculations to help troubleshoot nested formulas?

A. Trace Dependents map

B. Error Checking guide

C. Watch Window tool

D. Evaluate Formula

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Evaluate Formula tool on the Formulas tab steps through each part of a formula in sequence, showing calculated values at each step to simplify debugging.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, which function is used to perform a vertical lookup with approximate match?

A. INDEX MATCH

B. HLOOKUP

C. VLOOKUP(lookup_value, table_array, col_index, TRUE)

D. XLOOKUP

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
VLOOKUP with TRUE (or omitted) performs approximate match.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

What is the default font and size in MS Word 2016?

A. Calibri, 12 pt

B. Calibri, 11 pt

C. Times New Roman, 12 pt

D. Arial, 10 pt

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Default font is Calibri 11 pt since Word 2007.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs