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

The following marks are obtained by 8 students in an examination

Ascertain the grade obtained by students based on the following criteria

1 Answer

0 votes
by (27.3k points)
selected by
 
Best answer

Procedure: 

Step 1 – Open Libre Office Cal work sheet Applications → Office → Libre Office calc

Step 2 – Enter the data in the given cells

Step 3 – Enter the following formula in cell D2 = IF(C2 < 30, “FAIL”, IF(C2 < 40, “D+”, IF(C2 < 50, “C”, IF(C2<60, “C+”, IF(C2 < 70, “B”, IF (C2 < 80, “B+”, IF(C2 < 90, “A”, IF(C2 < 100, “A+”)))))))) 

Step 4 – Drag the formula to D9 

Output:

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.

...