Chicago White Sox
EXCEL PROJECT 5 (Submission: 2 pages)
Major League Baseball is the highest level of play in professional baseball in the world. Major League Baseball refers to the entity that operates North America’s two top leagues: The National League (NL) and the American League (AL). The Major league season generally runs from early April through the end of October. There are 30 teams in the 2 leagues: 16 in the National league and 1 in the American League.
When the regular season ends, eight teams enter the post-season playoffs. In 2005, the Chicago White Sox were the World Champions. This assignment shows how spreadsheets can be used to list and computer baseball statistics.
Skills: Formulas, Right click copy functions, Formatting
INSTRUCTIONS
1. Create a NEW spreadsheet. Font=Arial, Size=10 point.
2. Type the data as shown
3. Format the width of column A to 18.0 and left align.
4. Bold cell A2 and change the font size to 14 point.
5. Bold rows 4, 23, 26 and 41
6. Underline rows 4 and 26
7. Center align columns B – K
8. Enter the formula for the AVG (Batting Average) for the first player as follows:
AVG=HITS/AB (NOTE: AB (At Bats). In cell F6, type =E6/D6
9. Use right click, copy & paste the Batting Averages (AVG) formula down column F for the remaining players
10. Format cells F6 – F23 as numbers displaying 3 decimal places.
11. Enter the formula for the E.R.A. (Earned Run Average) for the first pitcher as follows:
E.R.A.=Runs/Innings*9. In cell G28, type =F28/E28*9
12. Use the right click, copy and paste the Earned Run Averages (E.R.A.) formula down in column G for the remaining pitchers.
13. Format cells G28 – G41 as numbers displaying 2 decimal places.
14. Use the Sum function to compute the TOTALS for all columns with the exception of the AVG and E.R.A. columns. These columns require a different formula (next step) since you cannot sum averages.
15. Compute the totals of the AVG and E.R.A. columns as follows:
a. Total AVG. In cell F23, type =E23/D23
b. Change the number format in Cell F23 to 3 decimal places.
c. Toal E.R.A. In cell G41,type =F41/E41*9
d. Change the number format in Cell G41 to 2 decimal places
16. Carefully proofread your work for accuracy.
17. Analyze the data in the project. What is this information used for?
18. Set the Print Area to include all cells containing data in the spreadsheet.
19. PRINT PREVIEW and adjust the Page Setup so that the spreadsheet fits on 1 PAGE. Set the page orientation to landscape and the page margins to .50 inches.
20. Now go back and check the formulas you used.
a. <CTRL>+` will show the formulas and formatting you used.
21. Save the spreadsheet in your Excel directory on your X drive as WHITE SOX.
22. Email assignment to your teacher.
note: Remember…always end your right click, copy function by hitting the enter key!
1