What are the different types of functions available in the Electronic Spreadsheet? Explain them with examples.
10 marks
Question source
- Exam year
- 2080 BS / 2024 AD
- Level
- Assistant Sub-Inspector (Prabidhik – IT/Computer)
- Paper
- Paper II – Professional and Service Specific Test
- Section
- Section B
Model answer
Functions are ready-made formulas that calculate without manual long expressions and auto-update on data change.
Types with examples:
1. Math: =SUM(A1:A10) total, =ROUND(12.567,2) → 12.57, =MAX(B2:B20) highest marks.
2. Statistical: =AVERAGE(C2:C20) mean attendance, =COUNT(D2:D50) numeric entries, =COUNTIF(E2:E50,">80") distinctions.
3. Logical: =IF(F2>=40,"Pass","Fail"); =IF(AND(B2>=80,C2>=90),"Scholarship","No"); =IF(OR(D2>=40,E2>=40),"Pass","Fail").
4. Text: =CONCAT(A2," ",B2) full name, =LEFT("KATHMANDU",3) → KAT, =LEN("Nepal") → 5, =UPPER("ram") → RAM.
5. Date/Time: =TODAY() current date, =NOW() date+time, =DATEDIF(DOB,TODAY(),"Y") age in years.
6. Lookup: =VLOOKUP(101,A2:D100,3,FALSE) salary of ID 101; XLOOKUP is modern replacement.
For full marks give category + syntax + one-line use, as above. Most-asked in exams: SUM, AVERAGE, IF, COUNTIF, VLOOKUP.