EXCEL ACTIVITY 25 - Weebly



EXCEL ACTIVITY 25

Charting Averages – Review Charts

1. Open a blank Excel spreadsheet workbook. Set up under Page Set-up for landscape format, footer with name and Activity 25, gridlines and headers showing.

2. You will need to input the following information into the spreadsheet. How you decide to lay it out is up to you. The title should read: Otah Gungah Bowling League.

Date Team C-3PO Team R2-D2

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 and use a fill color to identify the team with the highest average.

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 using Edmodo or as directed by your teacher.

-----------------------

What’s Happening: The droids have been in a bowling tournament in the underwater city of Otah Gunga. The protocol droids, such as C-3PO, have been in competition with the information droids such as R2-D2. 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!

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download