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
297 views
in Spread Sheet by (25.6k points)
closed by

Mark summary of some students are given below.

Calculate 

1. Number of cells containing 90 marks 

2. Count the number of paper scored less than 40 

3. Find the result of each student. (Pass or Fail) minimum mark required to pass is 30

1 Answer

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

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:

1 3
2 11

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.

...