Page 149 - Excle-En-V3

To calculate number of passed students in F10 or the number of failed students
in F11 cell, use the following function:

=COUNTIF(F3:F6,"passed")
=COUNTIF(F3:F6,"failed")
Repeat the steps above so that the grades and evaluation are calculated for each
of the students stored in the workbook.
In the following worksheet you will use a set of functions that recall data from
another worksheet. Make the 'student name' field, in which you will write the name
of the student to be searched for. Make the 'student’s status' field, 'student
evaluation' and 'student serial number'. In front of these fields, use the following
functions:

Figure 221: Student's status query

141 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024