Pareto Chart
1. The problem asks which option correctly describes the steps to create a Pareto chart in Excel.
2. A Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the cumulative total is represented by the line.
3. In Excel, the correct way to insert a Pareto chart is: Insert → Recommended Charts → All Charts → Pareto.
4. Option a) matches this exact sequence.
5. Options b), c), and d) describe other chart types (Histogram, Line chart, Bar chart + Line chart) which are not the Pareto chart.
6. Therefore, the correct answer is option a).
Final answer: a) Insert → Recommended Charts → All Charts → Pareto