1. In cell J5, create a calculation to find the new salary for the player, increased by the percentage entered in cell H2. For example, if 10% is entered into cell H2, then the result down column J will be that player's current salary +10% of their salary. There is a requirement here for both relative and absolute cell references....................................................__/4
2. In cell B62, enter a function to count the number of players using the data in column B. .............__/2
3. In cell E62 and J62, enter a function to automatically add up the numbers above. .......................__/2
4. Enter a function in cell K5 that will display For Review if the player's salary increase (the difference between the New Salary and the Old Salary) is more than $250,000, otherwise display OK. Copy the function down the remainder of the column. __/4
5. Format the values in Columns E and J as Currency with no decimals, but with commas at the thousands position. Save your worksheet..........................................................................................................................................__/2
6. Sort the data. The first sort should be by Position, Team and within that, sort by Salary. ............__/4