undefined

Question 1 (1 point) A B D E F 1 Q2 Total Q1 25 147 32 2 Salesperson 3 Brown, Judy 4 White, Samuel 5 Black, Jason 6 Redding, Charles 7 2012 Sales Q3 Q4 41 36 45 18 37 36 33 53 49 29 30 41 Total Sales for 2012: 123 64 199 44 144 613 You want to compare the sales figures for all four quarters for all of the Salespeople. What is the best chart to use? scatter column or bar line pie Question 2 (1 point) F 45 1 2 Salesperson 3 Brown, Judy 4 White, Samuel 5 Black, Jason 6 Redding, Charles 7 Q1 25 32 64 D E 2012 Sales Q2 Q3 Q4 41 36 18 37 36 53 49 29 30 Total Sales for 2012: Total 147 123 199 33 44 41 144 613 What is the data you would use? A2:F6 A1:76 A1:E6 A2:E6 Question 3 (1 point) B D E F Q1 25 1 2 Salesperson 3 Brown, Judy 4 White, Samuel 5 Black, Jason 6 Redding, Charles 7 Total 147 32 2012 Sales Q2 Q3 Q4 41 36 45 18 37 36 33 53 49 29 30 41 Total Sales for 2012: 123 64 199 44 144 613 You want to chart the Q4 sales figures for each salesperson to see what percent each contributed. What is the best chart to use? scatter pie column or bar line estion 4 (1 point) A B C D E F Total Q1 25 1 2 Salesperson 3 Brown, Judy 4 White, Samuel 5 Black, Jason 6 Redding, Charles 7 2012 Sales Q2 Q3 Q4 41 36 45 18 37 36 33 53 49 29 30 41 Total Sales for 2012: 147 123 32 64 199 44 144 613 What is the data series you would use? A2:A6,E2:E6 A2:A6,F2:F6 A2:A6,F2:F7 A2:F6 Question 5 (1 point) B C D E F A 1 2 Salesperson 3 Brown, Judy 4 White, Samuel 5 Black, Jason 6 Redding, Charles 7 Q1 25 2012 Sales Q2 Q3 41 36 Q4 45 Total 147 32 18 37 36 123 64 33 53 49 199 44 29 30 41 144 Total Sales for 2012: 613 Judy Brown is your newest salesperson. You want to chart the progress of her sales over the year. What is the best chart for you to use? pie column or bar line scatter