Advanced Spreadsheet Features

Question 1 • CHS- TX-Professional Communications (CR)

Which of the following are logical reasons for using a pie chart to show how employees spend their time at ABC Organization? Choose all that apply.

Answer

ABC Organization has twenty-five employees; a pie chart works well to show the breakdown of hours worked by all employees at ABC Organization.

Seasonal differences in employee productivity are a problem at ABC Organization, and the managers would like to discuss these variances with employees; a pie chart works well to show changes in productivity over the course of a year.

The “other” category contains a sizeable chunk of hours that may be time wasted; managers can use the pie chart to discuss possible lapses in productivity with employees.

Monthly trends in customer support hours will help determine when the highest call volume occurs so extra employees can be scheduled during those periods; a pie chart works well to show trends in data.

Explanation

A pie chart is useful for showing how a whole is divided into categories. Choice A describes breaking all employees’ hours into parts, and choice C uses the chart to examine the sizeable “other” portion of the total. Choices B and D focus on changes or trends over time, which are generally clearer in a line or bar chart than in a pie chart.

AI-written and checked against the verified answer.

More from this Course

Assignment

20 verified answers

Advanced Spreadsheet Features

Part 4

Part 1