際際滷

際際滷Share a Scribd company logo

Calculating Percents

drussell
drussell

This document provides instructions for creating a spreadsheet to calculate winning percentages for several sports teams. Key information includes: 1) It describes setting up the spreadsheet with column headings for team name, wins, losses, total games, and percent won. 2) It provides sample data for the number of wins and losses for teams like the Lakers, Suns, Blazers, and others. 3) Instructions are given to automatically calculate totals and percentages using formulas. 4) Formatting steps are included to bold headings, fill formulas down, and adjust decimal places.

1 of 10
Calculating Percents Spreadsheet Type the title, Sport Teams Records in cell C1 Type your name in cell A2 Type the column headings in row 3 as follows: Cell A3 Teams Cell B3 Won Cell C3 Lost Cell D3 Total Cell E3 Percent Won
Team Names Enter the team names in Column A Lakers Suns Blazers Bulls Magic Sonics
Format Headings Format all the HEADINGS and TEAM NAMES Select cell A1 and holding the left mouse button go over and down to E9 Then click the Bold button the B in the tool bar
Enter Wins Enter the wins for each team in Column B Lakers 45 Suns 30 Blazers 32 Bulls 48 Magic 38 Sonics 47
Enter Loses Enter the losses for each team in Column C Lakers 30 Suns 45 Blazers 43 Bulls 27 Magic 38 Sonics 29
Totals Compute the total number of games for each team in Column D Select D4 In the formula bar at the top enter this: = B4 + C4 (no spaces) Press ENTER The total number should appear in cell D4
Totals Click on D4 and drag your mouse down to D9 With the text still highlighted, click Edit then Fill, then Down This adds all your scores without making you add each team.
Percent of Wins The formula for percent is Wins divided by Total Games times 100. This is a 2 step process. Click on cell E4 Enter this formula into the formula line =B4/D4*100 Now, click on E4 and highlight to E9 Click Edit, Fill, Down
Changing decimal points Highlight Column E Go to Format Cells Number You can change the number of decimal places by using the up arrow Click OK
Congratulations You have now completed your first spreadsheet

More Related Content

Calculating Percents

  • 1. Calculating Percents Spreadsheet Type the title, Sport Teams Records in cell C1 Type your name in cell A2 Type the column headings in row 3 as follows: Cell A3 Teams Cell B3 Won Cell C3 Lost Cell D3 Total Cell E3 Percent Won
  • 2. Team Names Enter the team names in Column A Lakers Suns Blazers Bulls Magic Sonics
  • 3. Format Headings Format all the HEADINGS and TEAM NAMES Select cell A1 and holding the left mouse button go over and down to E9 Then click the Bold button the B in the tool bar
  • 4. Enter Wins Enter the wins for each team in Column B Lakers 45 Suns 30 Blazers 32 Bulls 48 Magic 38 Sonics 47
  • 5. Enter Loses Enter the losses for each team in Column C Lakers 30 Suns 45 Blazers 43 Bulls 27 Magic 38 Sonics 29
  • 6. Totals Compute the total number of games for each team in Column D Select D4 In the formula bar at the top enter this: = B4 + C4 (no spaces) Press ENTER The total number should appear in cell D4
  • 7. Totals Click on D4 and drag your mouse down to D9 With the text still highlighted, click Edit then Fill, then Down This adds all your scores without making you add each team.
  • 8. Percent of Wins The formula for percent is Wins divided by Total Games times 100. This is a 2 step process. Click on cell E4 Enter this formula into the formula line =B4/D4*100 Now, click on E4 and highlight to E9 Click Edit, Fill, Down
  • 9. Changing decimal points Highlight Column E Go to Format Cells Number You can change the number of decimal places by using the up arrow Click OK
  • 10. Congratulations You have now completed your first spreadsheet