HPRCA JOA IT Sorting, Filtering, Pivot Table, Goal Seek and Scenario PYQs

29 previous year questions on Sorting, Filtering, Pivot Table, Goal Seek and Scenario (MS Office - Excel) in 12 HP Junior Office Assistant (IT) papers, 2026, 2022, 2021: 1.6% of all the JOA IT questions we hold.

Questions
29
Papers
12
Years
2021-2026

What to study in Sorting, Filtering, Pivot Table, Goal Seek and Scenario

  • Sort and filter, AutoFilter
  • Pivot table
  • Goal Seek, Scenario Manager, what-if analysis
  • Data validation, freeze panes, subtotal

Sorting, Filtering, Pivot Table, Goal Seek and Scenario questions by year

YearQuestions
202615
20223
202110

Sample Sorting, Filtering, Pivot Table, Goal Seek and Scenario questions

Answers, explanations and all 29 questions are in the practice app.

Question 35 · Syllabus as per Essential Qualification

Which feature in MS Excel allows you to organize a list of employee names in alphabetical order without changing the data in other columns?

  1. (A)Group data
  2. (B)Sort by selected column
  3. (C)Sort by multiple columns
  4. (D)Filter data
Show in Hindi

MS एक्सेल का कौन-सा फ़ीचर, आपको दूसरे कॉलम के डेटा को बदले बिना कर्मचारियों के नामों की लिस्ट को वर्णमाला के क्रम में व्यवस्थित करने की सुविधा दे ता है?

  1. (A) ग्रुप डेटा (Group data)
  2. (B) सिलेक्ट किए गए कॉलम द्वारा सॉर्ट (Sort by selected column)
  3. (C) मल्टीपल कॉलम द्वारा सॉर्ट (Sort by multiple columns)
  4. (D) फिल्टर डेटा (Filter data)

Question 36 · Syllabus as per Essential Qualification

Which action enables you to view only the data for a specific region in a Pivot Table?

  1. (A)Inserting a slicer for the region
  2. (B)Sorting the region field
  3. (C)Applying a filter to the region field
  4. (D)Refreshing the data source
Show in Hindi

कौन-सी क्रिया आपको पिवट टे बल में केवल किसी विशिष्ट क्षेत्र (region) का डेटा दे खने की सुविधा दे ती है?

  1. (A) क्षेत्र के लिए स्लाइसर इन्सर्ट करना
  2. (B) क्षेत्र फ़ील्ड को सॉर्ट करना
  3. (C) क्षेत्र फ़ील्ड पर फ़िल्टर अप्लाई करना
  4. (D) डेटा सोर्स को रिफ़्रे श करना

Papers with Sorting, Filtering, Pivot Table, Goal Seek and Scenario questions

Frequently asked questions

How many Sorting, Filtering, Pivot Table, Goal Seek and Scenario questions have come in JOA IT?
29 questions in 12 of the 16 papers on AiPYQs (2026, 2022, 2021), about 1.6% of all JOA IT questions we hold.
Are these the official JOA IT previous year papers?
No. They are memory-based sample papers submitted by students for analysis, not official papers. Answers in the practice app are labelled with their source.
Where can I practise Sorting, Filtering, Pivot Table, Goal Seek and Scenario PYQs with answers?
In the AiPYQs practice app: sign in with Google and the first 50 questions of JOA IT are free every day. The exam plan unlocks every question with answers, AI Insights and a study planner.