Employees Provident Fund2071 BSQuestion 4 of 4
What is the benefit of using built-in functions in Microsoft Excel? What are those?
5 marks
Question source
- Exam year
- 2071 BS / 2015 AD
- Level
- Level 5 (Barishtha Computer Sahayak, Prabidhik)
- Paper
- Part 2, Section Kha – Short Answer
- Section
- Part 2, Section Kha: Short Answer
Model answer
Built-in functions are ready formulas that calculate without manual long expressions and auto-update — consistent with ASI/SI terminology.
Benefits: =SUM(A1:A10) beats =A1+A2+... in speed and errors; IF/VLOOKUP handle logic impossible manually; results refresh on data change; standard names ease audit.
Types with examples:
- Math:
SUM(),AVERAGE(),MAX(),MIN(),ROUND(). - Logic:
IF(C2>=40,"Pass","Fail"),AND()/OR()combos for EPF eligibility. - Text:
CONCAT(),LEFT(),LEN(),UPPER()for member names. - Date:
TODAY(),DATEDIF(DOB,TODAY(),"Y")for age/service years. - Lookup:
VLOOKUP(101,A2:D100,3,FALSE)pulls balance of ID 101.