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

The recruitment process of language teachers in a school consists of three items like interview, group discussion and paper presentation. A candidate has to qualify any one of the three tests to qualify for the written test. The prescribed standard for the items are given below. 

  • Interview – 16 score out of 20. 
  • Group Discussion – 25 score out of 30. 
  • Paper Presentation – 40 score out of 50

Other informations are also available.

Sl. No. Name Interview Group discussion Paper Presentation
1 Leela 17 26 46
2 Kripa 15 22 35
3 Ravi 14 27 37
4 Murali 18 29 41
5 Lini 15 28 44

Write a formula using OR function to check whether a candidate qualify or not. 

1 Answer

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

Step 1 – Open a blank work sheet in LiberOffice Calc. 

Step 2 – Enter the available data in work sheet

Step 3 – Enter the formula in F2 and copy it to the last candidate 

= IF(OR (C2>=16, D2>=25, E2>=40) “Qualied for the written Test”, “Not Qualied”)

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.

...