Civil Service Hospital2080 BSQuestion 6 of 10
How does worksheet differ from workbook? Explain the use of IF and AND functions with suitable examples.
10 marks
Question source
- Exam year
- 2080 BS / 2023 AD
- Level
- Level 5 (Prabidhik, Engineering and Maintenance, Computer Technician)
- Paper
- Paper II – Technical Subject
- Section
- Section B
Model answer
Workbook (.xlsx) is the whole Excel file; worksheet (Sheet1, Sheet2) is one grid page inside it. Workbook = register, worksheet = one page. One workbook holds many sheets (salary, attendance) linked by formulas like =Salary!B2.
IF and AND:
IF(test, true_val, false_val)decides.=IF(C2>=40,"Pass","Fail")— 40+ passes.AND(c1,c2,...)true only if all true. Combined:=IF(AND(B2>=80,C2>=90),"Scholarship","No")— needs both marks 80+ and attendance 90+. With B2=85, C2=92 → Scholarship; C2=80 → No.- OR variant:
=IF(OR(D2>=40,E2>=40),"Pass","Fail")passes if either theory or practical 40+. Hospital use:=IF(AND(Temp>100,Symptoms="Yes"),"Isolate","OPD").