Procedure:
Step 1 – Open a new blank worksheet in LiberOffice Calc
Step 2 – Enter the following details in the respective cells.

A 
B 
C 
1 
Name 
Mark 
Grade 
2 
Anand 
85 
A 
3 
Binary 
98 
A+ 
4 
Cili 
94 
A+ 
5 
Dona 
78 
B+ 
6 
Emin 
62 
B 
7 
Finto 
ab 

8 
Gigi 
75 
B+ 
9 
Honey 
ab 

Step 3 – Enter the text /formula in the corresponding
Output:
Total number of Students 
8 
Students appeared inclass test 
6 
Students with no grade 
2 
Number of A+ holders 
2 
Number of B grade holders 
1 