Advanced Spreadsheet Features

Question 1

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.

Revolt · Accepted 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.; 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.

Question 2

The value shown in B18

Revolt · Accepted Answer

does not include the values of B5, B9, B13, and B17.

Question 3

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

Revolt · Accepted Answer

The subtotal function

Question 4

Using the table to the right, answer the following questions.Values shown in B5, B9, B13, and B17 represent

Revolt · Accepted Answer

subtotals.

Question 5

Which of the following explains why librarians would apply conditional formatting to the library patron’s account spreadsheet?

Revolt · Accepted Answer

to quickly locate patrons who have overdue books

Advanced Spreadsheet Features Answers

More from this Course

TRY EDGENUITY HACKS