HPRCA JOA IT Charts in Excel PYQs

5 previous year questions on Charts in Excel (MS Office - Excel) in 5 HP Junior Office Assistant (IT) papers, 2026, 2022, 2021: 0.3% of all the JOA IT questions we hold.

Questions
5
Papers
5
Years
2021-2026

What to study in Charts in Excel

  • Column, bar, line, pie, area and scatter charts
  • Chart elements and sparklines

Charts in Excel questions by year

YearQuestions
20263
20221
20211

Sample Charts in Excel questions

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

Question 38 · Syllabus as per Essential Qualification

A user in MS Excel (Microsoft 365 and Office 2021) wants to present survey results with a visual ranking of categories. Which chart type will best facilitate this objective?

  1. (A)Area chart
  2. (B)Doughnut chart
  3. (C)Line chart
  4. (D)Bar chart
Show in Hindi

MS एक्सेल (माइक्रोसॉफ्ट 365 और ऑफिस 2021) में एक यूजर श्रेणियों की विजुअल रैंकिंग के साथ सर्वेक्षण के परिणामों को प्रस्तुत करना चाहता है। इस उद्देश्य के लिए कौन-सा चार्ट प्रकार सर्वोत्तम रहेगा?

  1. (A) एरिया चार्ट (Area chart)
  2. (B) डोनट चार्ट (Doughnut chart)
  3. (C) लाइन चार्ट (Line chart)
  4. (D) बार चार्ट (Bar chart)

Question 36 · Syllabus as per Essential Qualification

What is the meaning of a Workbook in Microsoft Excel (2019 or later)?

  1. (A)A mathematical formula only
  2. (B)A collection of one or more worksheets
  3. (C)A chart used for visualization of data
  4. (D)An area in the active worksheet
Show in Hindi

माइक्रोसॉफ्ट एक्सेल (2019 या बाद के वर्जन) में वर्क बुक का क्या अर्थ है?

  1. (A) केवल एक गणितीय फ़ॉर्मूला
  2. (B) एक या एक से अधिक वर्क शीट का कलेक्शन
  3. (C) डेटा विज़ुअलाइजेशन के लिए उपयोग किया जाने वाला चार्ट
  4. (D) एक्टिव वर्क शीट में कोई एरिया

Papers with Charts in Excel questions

Frequently asked questions

How many Charts in Excel questions have come in JOA IT?
5 questions in 5 of the 16 papers on AiPYQs (2026, 2022, 2021), about 0.3% 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 Charts in Excel 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.