AutoSave O OFF 1 W10 Assignment Q Sear Home Insert Draw Page Layout Formulas Data Review View Chart Design Format Calibri (Body) 10 A A ab Wrap Text General Paste BIUV Merge & Center $ ~ % " Conditional Format Cell Insert Delete Format Formatting as Table Styles X v Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Chart 1 + x fx C F G H I J K L M N . P Q R S U V W X Communication Activities as a Percent of Time Managers engage in a variety of commu ication activities during their work day. Eight managers estimated the time they spend each engaged in four kinds of communication The data collected is sho Audree: listening. 30.0%; speaking. 20.0%; reading. 15.0%; writing, 5.0% Communication Activities as a Percent of Time Benjamin: listening, 30.0%; speaking, 10.0%%; reading, 20.0%%; writing, 20.0%% 9 Cole: listening, 25.0%%; speaking, 5.0%%; reading, 10.0%%; writing, 40.09 10 Dean: listening, 35.0%; speaking, 20.0%; reading, 10.0%%; writing, 5.0% 11 Emerson: listening, 25.0%%; speaking, 35.0%%; reading, 20.0%%; writing, 5.0% 12 Frank: listening, 20.0%; speaking, 15.0%%; reading, 40.0%%; writing, 5.0% 13 Gabby: listening, 25.0%%; speaking, 20.0%; reading, 10.0%; writing, 10.0% Listening Hester: listening, 30.0%%; speaking, 35.0%%; reading, 10.0%; writing, 5.0% Other Activities 27.50%% 15 23.75% 16 Look at the spreadsheet below to see how it is set up. 17 Notice that the data for Audree has already been entered. The pie chart at the bottom of the page illustrates the averages for all data entered. At this 19 point it only reflects the data for Audree. Writing 20 Enter the data for the seven other managers in the white cells. 11 88% When you finish entering the data, the pie chart will illustrate the averages for all the data. E 22 If you have entered the data correctly, the slices will be divided as follows: listening, 27.5%; Speaking 23 speaking, 20%; reading, 16.88%%; writing, 11.88%; and other, 23.75%. 20.00%% 24 Reading 25 16.88% 26 Communication Activities as a Percent of Time Other Total 27 Listening Speaking Reading Writing Activities 28 Average 30.00% 20.00% 15.00% 5.00% 30.00% 100.0% 29 Audree 30.00% 20.00% 15.00% 5.00% 30.00% 100.0% 30 Benjamin 0.0% 31 Cole 0.0% 32 0.0% Dean 33 0.0% Emerson 0.0% Frank 0.0% Gabby 0.0%% + Hester