Microsoft Excel 2013 77-420 Question # 6 Topic 1 Discussion

Microsoft Excel 2013 77-420 Question # 6 Topic 1 Discussion

77-420 Exam Topic 1 Question 6 Discussion:
Question #: 6
Topic #: 1

Formula

Find the average score of all student ids without a zero homework score.

Cell L2

Use Function AVERAGEIF

Range F7:F29

Criteria: "0"

Average_range: "Homework"


Get Premium 77-420 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.