Find the average score of all student IDs without a zero homework score using the AVERAGEIF function. The Range is F7-F29, Criteria is "0", and Average_range is "Homework".

Step 1: Click cell L2, and then click the Insert Function Button. Step 2: In the Insert Function dialog box, select 'Statistical' from the Category, select 'AVERAGEIF' function, and click OK.

Perform Operations with Formulas and Functions

Question

Find the average score of all student IDs without a zero homework score using the AVERAGEIF function. The Range is F7-F29, Criteria is "0", and Average_range is "Homework".

Explanation

Step 1: Click cell L2, and then click the Insert Function Button. Step 2: In the Insert Function dialog box, select 'Statistical' from the Category, select 'AVERAGEIF' function, and click OK.

Topics

#AVERAGEIF function#conditional average#named range#criteria

Community Discussion

No community discussion yet for this question.

Full 77-420 Practice