Exam prep that stays consistent

IT Study

Daily practice space for computer operator and IT-focused exams. Build streaks, revise key topics, and keep your momentum.

Navigation

MCQ library
Institute exam sets
Section One quiz
One Line
Mistake practice
Free notes
Theory vault
Subjective
Syllabus
Past papers
Answer review

Resources

Practice Mistakes

Tools

Vacancy Updates

Copyright 2026 IT Study. All rights reserved.

Weekly activity map shows your real consistency.

Home/Past Papers/Karnali Pradesh Loksewa Computer Technician Subjective Exam – 2079/Briefly describe about any five functions available in the Electronic Spreadsheet with examples.

View complete paper

Karnali Province•2079 BS•Question 2 of 3

Briefly describe about any five functions available in the Electronic Spreadsheet with examples.

5 marks

Question source

Exam year: 2079 BS / 2022 AD
Level: Level 5 (Sahayakstar)
Paper: Section Kha – Short Answer
Section: Section Kha: Short Answer

Model answer

Ready-made functions save time and auto-update (consistent with SI/ASI papers):

SUM: =SUM(A1:A10) — total budget.
AVERAGE: =AVERAGE(B2:B20) — mean attendance.
IF: =IF(C2>=40,"Pass","Fail") — result decision.
COUNTIF: =COUNTIF(D2:D50,">80") — distinctions count.
VLOOKUP: =VLOOKUP(101,A2:D100,3,FALSE) — salary of ID 101.

Each needs correct syntax and range — most-asked set for 5 marks.

Previous questionQuestion 1: What are the functions of the following networking devices: Switch, Router, Access Point, Firewall and Modem?Next question Question 3: What is the importance of software testing? Mention any two types of software testing.

Question 2 of 3 from Karnali Pradesh Loksewa Computer Technician Subjective Exam – 2079

Open all questions