Microsoft
77-420 · Question #9
77-420 Question #9: Real Exam Question with Answer & Explanation
Sign in or unlock 77-420 to reveal the answer and full explanation for question #9. The question stem and answer options stay visible for context.
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".
Unlock 77-420 to see the answer
You've previewed enough free 77-420 questions. Unlock 77-420 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.