$1.$

Question $1$

Open the attached workbook. Have a look at the HR Data sheet which contains a list of all staff who have worked at the company since $1990.$ You are required to take over creating a report to show staffing levels and salary metrics. Go to the Calcs sheet. Some data has already been prepared. Look at the data in A$3$:C$14,$ it shows the number of staff in each role within each department. Which of the following Excel chart types are suitable for showing this data visually? $($More than one may apply.$)$

$1$ point

Sunburst Chart

Pie Chart

Waterfall Chart

Treemap Chart