In Excel, which chart type shows the proportion of each data series relative to the total using nested rings? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, which chart type shows the proportion of each data series relative to the total using nested rings?

A. Pie

B. Doughnut

C. Sunburst

D. Treemap

Answer: Option B

Solution (By JKSSB Mock Tests)

Doughnut chart is like a pie with a hole, can show multiple series. Sunburst shows hierarchical rings.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1

In Excel, the 'Goal Seek' tool is found under:

A. Review tab

B. Formulas tab

C. Insert tab

D. Data tab -> What-If Analysis -> Goal Seek

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Goal Seek is under Data > What-If Analysis.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, to create a form that automatically adjusts to the size of the window, you can use:

A. Property 'Auto Resize'

B. Layout View and anchoring

C. Design View with auto-resize

D. All of the above

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Anchoring controls in Layout View helps responsive design.

This question belongs to: Computer Microsoft Office

Question #3

In PowerPoint, what is the purpose of the 'Slide Show' tab?

A. To design slides

B. To review spelling

C. To set up and control slide show settings, rehearsals, and monitors

D. To insert media

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Slide Show tab manages presentation delivery.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs