Procedure:
Step 1 – Open Libreoffice Calc worksheet Application → Office → LibreOffice calc
Step 2 – Enter the given data in appropriate cells
Step3 – Enter the following details and formula in appropriate cells
A8 |
Number of cells containing 90 mark |
B8 |
= COUNTIF(B2: G7, “90”) |
A9 |
Count the number of paper scored less than 40 Mark |
B9 |
= COUNTIF(B2: G7, “40”) |
Step4 – Find the result of the student
1st step – Count the number of marks less than 30 scored by each student For this, Enter the formula in
H2 =COUNT IF (B2: G2, “<30”)
Drag the equation to H7
2nd step – Based on the result in H2: H7 range, we can nd out the result in I2 cell by giving the following formula
=IF(H2 = 0, “PASS”, “FAIL”)
Drag (Copy) the formula to I7
Output: