AnswersCHS- TX-Professional Communications CRAdvanced Spreadsheet Features

Advanced Spreadsheet Features Answers

3 verified answers1 views
1
Free Preview

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.

A
ABC Organization has twenty-five employees; a pie chart works well to show the breakdown of hours worked by all employees at ABC Organization.
B
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.
C
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.
D
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.
2
Free Preview

The value shown in B18

A
is the sum of B2:B17.
B
is the average of B5, B9, B13, and B17.
C
does not include the values of B5, B9, B13, and B17.
3

allows you to calculate the sum of selected values without duplicating values in the grand total.

A
The subtotal function
B
The average formula
C
Conditional formatting

Did you find these answers helpful?

More from this Course

Assignment
1 verified answers

Part 4

Assignment
1 verified answers

Part 1

Assignment
4 verified answers

Advanced Spreadsheet Features