EXCEL ACTIVITY 25 Charting Averages Review Charts Whats

EXCEL ACTIVITY 25 Charting Averages – Review Charts What’s Happening: The droids have been in a bowling tournament in the underwater city of Otah Gunga. The protocol droids, such as C-3 PO, have been in competition with the information droids such as R 2 -D 2. You have been asked to set up an Excel spreadsheet to show the weekly bowling scores of the teams, their average scores, as well as charts comparing those scores. I finally scored over 100! 1. Open a blank Excel spreadsheet workbook. Use “landscape” format. 2. Input the following information into the spreadsheet. The title should read: Otah Gungah Bowling Le Date Team C-3 PO Team R 2 -D 2 Week 1 688 760 Week 2 550 725 Week 3 665 575 Week 4 600 490 Week 5 495 510 Week 6 550 540 Week 7 680 720 Week 8 825 590 Week 9 675 730 Week 10 700 680 3. Identify the appropriate cells, label, and input the formula to compute the AVERAGE score over the ten weeks for each team. Select the team with the highest score and use a fill color to identify them. 4. Create a line graph that compares the scores of the two teams over the 10 -week league. Make sure you label and identify all parts of the graph and title it. 5. Create a column chart that compares the AVERAGE scores of the two teams. Be sure to label all parts and title it. 6. Make sure both graphs and the data chart all fit on one page. Print Preview. Compare your final worksheet with the answer key. Save as SS Activity 25. Submit to teacher flash drive when instructed.