Page 148 - Excle-En-V3

After creating all the required keys, you can work on the main worksheet that
contains the students’ data and various functions (which can be hidden later so that
it does not appear to database users) such as the following worksheet:

Figure 220: "History" sheet

This worksheet contains students' data and their grades in different academic
subjects. Use the following functions:

To calculate the total score, click the total grades cell, which represents the E3
cell, and type the following function:

=SUM(B3:D3)
To calculate the student’s status (Passed or Failed, considering that the total
grades are 150 degrees), click on the F3 cell and use the following function:
=IF(E3>150,"passed","failed")
As E3 contains the total grades.
To the students' evaluation, click on G3 cell, and use the following function:
=IF(E3<150,"failed",IF(E3<160,"pass",IF(E3<170,"good",IF(E3<180,"very
good","excellent"))))

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