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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- linear regression in excel
- excel activity a weebly
- chemistry 101l boyd county public schools
- unit three kennesaw state university
- graphing with excel 2003 and 2007
- how to analyze tolerances using excel asq
- calculation of repeatability and reproducibility
- entering data into excel and finding the algebraic
- excel activity 25 weebly
Related searches
- top 25 property management companies
- 25 secret starbucks drinks
- top 25 investment firms
- 25 things about me questionnaire
- 25 facts about me questions
- morningstar top 25 mutual funds
- 25 questions about me
- 25 things about me ideas
- top 25 investment management firms
- 7.25 interest rate credit card
- 25 best school qatar
- 25 fun employee survey questions