Question

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. 

Answer 1

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: