際際滷

際際滷Share a Scribd company logo

Case Problem: Players.xlsx

V
ViscKand

Jeff DeMarco runs a basketball blog and created an Excel file to track NBA player data including team, position, and salary. He asks for assistance analyzing the data. The tasks include opening the Players file, adding formatting, sorting by position and salary, conditional formatting for high salaries, filtering by team using a slicer, and filtering for top salaries.

1 of 2
Download to read offline
Buy here: http://homeworknumber.one/products.php?product=-Ca se-Problem%3A-Players.xlsx Data File needed for this Case Problem: Players.xlsx NBA Hoops Blog Jeff DeMarco is a sports enthusiast. Several years ago, he began writing a basketball blog called NBA Hoops that provides Information, opinions, and analysis related to teams, players, and games in the National Basketball AssociatIon (NBA). To help him more easily respond to comments from his readers, he created an Excel table that tracks teams, positions, and salaries for each player in the league. He asks you to analyze thls data. Complete the following: 1. Open the Players workbook located M the Excel5 ? Case2 folder Included with your Data Res, and then save the workbook as NBA Player Data. 2. In the Documentation worksheet, enter your name and the date. 3. In the Players worksheet, create an Excel table named NBAPlayers. Format the Salary column with the Accounting format and no decimal places. Format the NBAPlayers table wIth the table style of your choice. 4. Make a copy of the Players worksheet, and then rename the copied worksheet as Sort PosItion. (Hint: Press the al key and drag the Players sheet tab to the right of the Players sheet tab to make a copy of the worksheet.) Sort the NBAPlayers table in ascending order by position, then in descending order by salary. 5. Use conditional formatting to apply a yellow fill with dark yellow text to highlight all players with a salary greater than $10,000,000.
6. Make a copy of the Players worksheet, and then rename the copied worksheet as Filter Team. Insert a slicer to filter by Team. Place the slicer to the right of the NBAPlayers table. Select a slicer style that matches the style you used to format the NBAPlayers table. Reese the slicer's height and width to Improve its appearance. 7. Use the slicer to filter the NBAPlayers table to display all players on the NY Knicks and Miami Heat teams. 8. Expand the filter to display NY Knicks and Miami Heat players earning more than 55,000,000. Sort the filtered table In ascending order by salary. 9. Make a copy of the Players worksheet, and then rename the copied worksheet as Filter Top 15%. Filter the NBAPlayers table to display players whose salaries are In the top 15 percent. Sort the data by Salary M descending order.

More Related Content

Case Problem: Players.xlsx

  • 1. Buy here: http://homeworknumber.one/products.php?product=-Ca se-Problem%3A-Players.xlsx Data File needed for this Case Problem: Players.xlsx NBA Hoops Blog Jeff DeMarco is a sports enthusiast. Several years ago, he began writing a basketball blog called NBA Hoops that provides Information, opinions, and analysis related to teams, players, and games in the National Basketball AssociatIon (NBA). To help him more easily respond to comments from his readers, he created an Excel table that tracks teams, positions, and salaries for each player in the league. He asks you to analyze thls data. Complete the following: 1. Open the Players workbook located M the Excel5 ? Case2 folder Included with your Data Res, and then save the workbook as NBA Player Data. 2. In the Documentation worksheet, enter your name and the date. 3. In the Players worksheet, create an Excel table named NBAPlayers. Format the Salary column with the Accounting format and no decimal places. Format the NBAPlayers table wIth the table style of your choice. 4. Make a copy of the Players worksheet, and then rename the copied worksheet as Sort PosItion. (Hint: Press the al key and drag the Players sheet tab to the right of the Players sheet tab to make a copy of the worksheet.) Sort the NBAPlayers table in ascending order by position, then in descending order by salary. 5. Use conditional formatting to apply a yellow fill with dark yellow text to highlight all players with a salary greater than $10,000,000.
  • 2. 6. Make a copy of the Players worksheet, and then rename the copied worksheet as Filter Team. Insert a slicer to filter by Team. Place the slicer to the right of the NBAPlayers table. Select a slicer style that matches the style you used to format the NBAPlayers table. Reese the slicer's height and width to Improve its appearance. 7. Use the slicer to filter the NBAPlayers table to display all players on the NY Knicks and Miami Heat teams. 8. Expand the filter to display NY Knicks and Miami Heat players earning more than 55,000,000. Sort the filtered table In ascending order by salary. 9. Make a copy of the Players worksheet, and then rename the copied worksheet as Filter Top 15%. Filter the NBAPlayers table to display players whose salaries are In the top 15 percent. Sort the data by Salary M descending order.