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 6
View complete paper
Janak Education Materials Centre•2082 BS•Question 6 of 16

Describe the process of sorting and filtering data in Microsoft Excel. Explain the benefits of using sorting and filtering in data analysis.

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

Sorting arranges data order; filtering isolates matching rows.

Previous questionQuestion 5: Write down two basic Excel formulas with functional meaning and syntax.Next question Question 7: Why do computers require memory? Explain the various types of primary and secondary memory used in a computer along with their functionalities.

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

Open all questions