Question

Mrs. Leela, the class teacher is analysing the performance of her students in a class test.

Find out 

• Total number of students 
• Number of students appeared in the class test 
• Number of students with no grade 
• Number of A+ holders 
• Number of B grade holders.

Answer 1

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 in-class test	6
Students with no grade	2
Number of A+ holders	2
Number of B grade holders	1