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
Year
Questions
2026
15
2022
3
2021
10
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?
(A)Group data
(B)Sort by selected column
(C)Sort by multiple columns
(D)Filter data
Show in Hindi
MS एक्सेल का कौन-सा फ़ीचर, आपको दूसरे कॉलम के डेटा को बदले बिना कर्मचारियों के नामों की लिस्ट को वर्णमाला के क्रम में व्यवस्थित करने की सुविधा दे ता है?
(A) ग्रुप डेटा (Group data)
(B) सिलेक्ट किए गए कॉलम द्वारा सॉर्ट (Sort by selected column)
(C) मल्टीपल कॉलम द्वारा सॉर्ट (Sort by multiple columns)
(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?
(A)Inserting a slicer for the region
(B)Sorting the region field
(C)Applying a filter to the region field
(D)Refreshing the data source
Show in Hindi
कौन-सी क्रिया आपको पिवट टे बल में केवल किसी विशिष्ट क्षेत्र (region) का डेटा दे खने की सुविधा दे ती है?
(A) क्षेत्र के लिए स्लाइसर इन्सर्ट करना
(B) क्षेत्र फ़ील्ड को सॉर्ट करना
(C) क्षेत्र फ़ील्ड पर फ़िल्टर अप्लाई करना
(D) डेटा सोर्स को रिफ़्रे श करना
Papers with Sorting, Filtering, Pivot Table, Goal Seek and Scenario 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.