Discussion
In MS Excel, what does the AVERAGE function ignore when calculating?
Answer: A
Correct answer: Empty cells and text
AVERAGE ignores empty cells and text, dividing only by the count of numeric entries. Negative numbers and decimals are included like any other value. The distinction that matters is between an empty cell and a cell containing zero. An empty cell is left out of both the total and the count; a zero is included in both and pulls the average down. A range with three values and two blanks averages over three; the same range with zeros in place of the blanks averages over five. AVERAGEA behaves differently, counting text as zero and including it in the divisor, which usually gives a lower and less useful figure. The conditional forms are AVERAGEIF and AVERAGEIFS, which average only the entries meeting given criteria. An average over an empty range returns #DIV/0!, since there is nothing to divide by.
Post your comment
Please log in or register to post a comment.
Examination Categories
- SSC Exams
- Banking Exams
- Teaching Exams
- Civil Services Exams
- Railways Exams
- Engineering Recruitment Exams
- Defence Exams
- State Government Exams
- Police Exams
- Insurance Exams
- Nursing Exams
- Other Government Exams
- NRA CET
- PG Entrance Exams
- Campus Placement
- MBA Entrance Exams
- CUET and UG Entrance
- Judiciary Exams
- Regulatory Body Exams
- Software Development