Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
265 views
in Spread Sheet by (27.3k points)
closed by

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.

1 Answer

+1 vote
by (25.6k points)
selected by
 
Best answer

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

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...