Question: 1. Set up Data Bars to visualize the data, where players making more money have longer data bars. 2.Duplicate the salary data to another column.
1. Set up Data Bars to visualize the data, where players making more money have longer data bars.
2.Duplicate the salary data to another column. Set up Icon Sets to summarize the NBA player data, where break points for icons are $12, $9, $6, and $3 million.
3.Duplicate the salary data to another column. Set up Color Scales to visualize the data by choosing Green-Yellow-Red color scale.4.Duplicate the salary data to a new column. Visualize the NBA salary data by the following manner The top 25percentile in red, 25-50 percentile in orange, 50-75 percentile in yellow, and the bottom 25percentile in green (Do not use anygradient; Hint: =PercentRank.)
5.The Column A shows NBA players names you want to separate these names into two columns one for the first name and the other for the last name. Use the Text to Columns function in the Dataribbon to complete the task.
I just need the excel formulas/how to's for the questions
D E F G H I J K L M N O P Q RS T U V W X Y B Salary 2.50 0.40 3.37 7.31 6.95 1.51 0.40 0.72 1.27 0.40 15.30 1.13 6.30 2.58 1 Player 2 Aaron Mckie 3 Aaron Miles 4 Aaron Williams 5 Adonal Foyle 6 Al Harrington 7 Al Jefferson 8 Alan Anderson 9 Alan Henderson 10 Aleksandar Pavlovic 11 Alex Acker 12 Allen Iverson 13 Alonzo Mourning 14 Alvin Williams 15 Amare Stoudemire 16 Amir Johnson 17 Anderson Varejao 18 Andray Blatche 19 Andre Igoudala 20 Andre Miller 21 Andre Owens 22 Andrei Kirilenko 23 Andres Nocioni 24 Andrew Bogut 25 Andrew Bynum 26 Andris Biedrins 27 Anfernee Hardaway 28 Antawn Jamison 29 Anthony Carter 30 Anthony Goldwire 31 Anthony Johnson 32 Anthony Robertson 33 Antoine Walker 34 Antoine Wright 25 Antonio Burke 0.40 0.87 0.40 2.05 8.10 0.40 10.90 3.70 4.34 1.88 1.85 15.70 13.80 0.72 0.72 2.42 0.40 6.88 1.46 064 D E F G H I J K L M N O P Q RS T U V W X Y B Salary 2.50 0.40 3.37 7.31 6.95 1.51 0.40 0.72 1.27 0.40 15.30 1.13 6.30 2.58 1 Player 2 Aaron Mckie 3 Aaron Miles 4 Aaron Williams 5 Adonal Foyle 6 Al Harrington 7 Al Jefferson 8 Alan Anderson 9 Alan Henderson 10 Aleksandar Pavlovic 11 Alex Acker 12 Allen Iverson 13 Alonzo Mourning 14 Alvin Williams 15 Amare Stoudemire 16 Amir Johnson 17 Anderson Varejao 18 Andray Blatche 19 Andre Igoudala 20 Andre Miller 21 Andre Owens 22 Andrei Kirilenko 23 Andres Nocioni 24 Andrew Bogut 25 Andrew Bynum 26 Andris Biedrins 27 Anfernee Hardaway 28 Antawn Jamison 29 Anthony Carter 30 Anthony Goldwire 31 Anthony Johnson 32 Anthony Robertson 33 Antoine Walker 34 Antoine Wright 25 Antonio Burke 0.40 0.87 0.40 2.05 8.10 0.40 10.90 3.70 4.34 1.88 1.85 15.70 13.80 0.72 0.72 2.42 0.40 6.88 1.46 064
Study Help