Excel Exercise 1 Instructions: 1) Save workbook as: Last Name, First Name, Excel Exercise 1 2) Rename Sheet 1 as: 20-21 Season Summary 3) Key in the following textumbers as shown in the image to the right -> C 4) Merge & Center the range Al :LI 1 NHL 2020-2021 Season Summary IN 5) In cell E4, use a formula to calculate the games played. The formula in E4 should read =SUM(B4:D4) Team Wins Losses Copy that formula down the column so the games played are calculated for every team. Vegas Golden Knights 40 6) In cell F4, use a formula to calculate the points earned where a win is worth 2 points and an overtime loss is Colorado Avalanche 39 Carolina Hurricanes 36 worth 1 point. 37 The formula in F4 should read: =(B4*2)+(D4*1) Florida Panthers Pittsburgh Penguins 37 Copy that formula down the column so the points are calculated for every team. Washington Capitals 36 7) In cell G4, use a formula to calculate the points earned as a percent of points possible. Toronto Maple Leafs 35 The formula in G4 should read =F4/(E4*2) Tampa Bay Lightning 36 Minnesota Wild 35 Copy that formula down the column so the points % is calculated for every team. Boston Bruins 33 8) From sheet called "Goals" copy the range B2:C32 and paste onto the sheet called 20-21 Season Summary Edmonton Oilers 35 into the range H4:134. New York Islanders 32 9) In cell J4, use a formula to calculate the Goal Differential or the difference between Goals For and Goals Nashville Predators 31 Winnipeg Jets 30 Against. St. Louis Blues 27 The formula in J4 should read =H4-14 New York Rangers 27 23 Copy that formula down the column so the Goal Differential is calculated for every team. 20 Dallas Stars 23 24 10) In cell K4, use a formula to calculate Goals For per Game Played Montreal Canadiens Philadelphia Flyers 25 The formula in K4 should read =H4/E4 23 Calgary Flames 26 Copy that formula down the column so the GF/GP is calculated for every team. 24 Chicago Blackhawks 24 11) In cell L4, use a formula to calculate Goals Against per Game Played 25 Arizona Coyotes 24 The formula in L4 should read =14/E4 26 Ottawa Senators 23 27 Vancouver Canucks 23 Copy that formula down the column so the GA/GP is calculated for every team. 28 Los Angeles Kings 21 12) Format as follows: 29 San Jose Sharks 21 a. Range A1:LI as Calibri font, bold, font size 20, and be center aligned 30 Detroit Red Wings 19 b. Range A3:L3 should have bold text, center aligned, and a bottom cell underline Columbus Blue Jackets 2 New Jersey Devils 30 c. Range A4-A34 should be left justified and range B4:L34 should be center aligned 33 Anaheim Ducks 17 30 J. Column G as a Percentage 4 Buffalo Sabres 15 34 . Column J as a custom number where a positive value shows the + and the negative value shows the - f. Column K as a number with 2 decimal points g. Column L as a number with 2 decimal points The worksheet titled "Grade Key" shows you what your work should look like at the end of the instructions.A C D E F G H NHL 2020-2021 Season Summary Goals Against per Overtime Games Goals Goal Goals For per Wins Losses Losses Played Points Points % Goals For Against Differential Game Played Game Played Team for every team. Vegas Golden Knights 40 14 2 39 13 worth 2 points and an overtime loss is Colorado Avalanche Carolina Hurricanes 36 12 Florida Panthers 37 14 Pittsburgh Penguins 37 16 ry team. Washington Capitals 36 15 35 14 oints possible. 10 Toronto Maple Leafs Tampa Bay Lightning 36 17 Minnesota Wild 35 16 ery team. Boston Bruins 33 16 eet called 20-21 Season Summary Edmonton Oilers 35 19 New York Islanders 32 17 Nashville Predators 31 23 ace between Goals For and Goals Winnipeg Jets 30 23 St. Louis Blues 27 20 New York Rangers 27 23 ed for every team. Dallas Stars 23 21 Montreal Canadiens 24 22 Philadelphia Flyers 25 23 Calgary Flames 26 ry team. 24 Chicago Blackhawks 24 25 Arizona Coyotes 24 26 26 Ottawa Senators 23 28 27 Vancouver Canucks 23 29 ry team. 28 Los Angeles Kings 21 29 San Jose Sharks 21 30 Detroit Red Wings 19 31 Columbus Blue Jackets 18 nderline 32 New Jersey Devils 19 ter aligned 33 Anaheim Ducks 17 34 Buffalo Sabres 15 34 he negative value shows the - work should look like at the