Microsoft Related Exams
77-420 Exam

Formula.
Count the number of 0 homework scores for each student.
Cell range F7:F29
Use function COUNTIF
Range: all possible homework scores for each student on "Section 3" worksheet.
Criteria: 0
Insert a picture.
To the right of the data
File source Books.jpg
Formula.
Find the minimum homework score for each student.
Cell range D7:D29
Number 1: minimum homework score for each student on "Section 3" worksheet.