IT Study
Section-one-quizTheory VaultFree NotesSubjectiveOne LineSyllabusPast PapersMCQ PracticeInstitutes
0 day streakSign in

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

  • Section-one-quiz
  • Theory Vault
  • Free Notes
  • Subjective
  • One Line
  • Syllabus
  • Past Papers
  • MCQ Practice
  • Institutes

Resources

  • Practice Mistakes

Tools

  • Vacancy Updates

Copyright 2026 IT Study. All rights reserved.

Weekly activity map shows your real consistency.

Home/Past Papers/Janak Education Materials Centre IT Exam – 2082/Question 5
View complete paper
Janak Education Materials Centre•2082 BS•Question 5 of 16

Write down two basic Excel formulas with functional meaning and syntax.

5 marks

Question source

Exam year
2082 BS / 2025 AD
Level
Level 5
Paper
Technical – Subjective
Section
Section A: Office Systems & Hardware (50 Marks)

Model answer

=SUM(A1:A10) and =AVERAGE(B1:B10).

Previous questionQuestion 4: Explain the step-by-step process of applying password protection to a Microsoft Word document to restrict editing and opening. Discuss why password protection is important.Next question Question 6: Describe the process of sorting and filtering data in Microsoft Excel. Explain the benefits of using sorting and filtering in data analysis.

Question 5 of 16 from Janak Education Materials Centre IT Exam – 2082

Open all questions