In Microsoft Excel, which chart type is best suited for comparing proportions or percentages of a whole?
Show answer & explanation
Correct answer: A
Explanation
The correct answer is option 1 i.e. Pie Chart.
In Microsoft Excel, the Pie Chart is best suited for comparing proportions or percentages of a whole. This chart visually represents data as slices of a circle, with each slice's size corresponding to the proportion or percentage of the total. Pie charts are ideal when you want to show how different categories contribute to a whole, such as market share or distribution of resources. Excel also allows the customization of pie charts with labels and colours to enhance clarity and visual appeal.