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

For SI selection in Kerala polices there is a physical test, which consists of three items. A candidate has to qualify ANY ONE of the three tests to qualify for the final. The standard for the physical test is given below. 

  • Shot put: 5 meters or above. 
  • Ball throws 50 meters. 
  • 500-meter race within 5 minutes. 

The following data is furnished:

Check whether the candidates quality or not. 

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 details in the form of a Table

Step 3 – Enter the following formula in F2 and drag with ll up to F6 = IF(OR(C2>=5, D2>=50, E2<=5), ‘‘Qualied”, “Not Qualied”) 

Output:

Chest No. Result
203 Qualified
2016 Qualified
275 Qualified
304 Not Qualified
361 Qualified

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.

...