Players Worksheet

$2.$Enter your name in cell B$2.$

$3.$In cell J$5,$ create a calculation to change the salary for the player by the percentage entered in cell H$2.$For example, if $14\%$ is entered into cell H$2,$ then the result down column J will be that player$$s current salary $+14\%.$There is a requirement here for both relative and absolute cell references.$\_\_/10$

$4.$Enter a function in cell K$5$ that will display Negotiate if the player$$s salary increase $($the difference between the New Salary and the Old Salary$)$ is more than $$300,000,$ otherwise display Approve. Copy the function down the remainder of the column.$\_\_/10$

$5.$Format the values in Columns E and J as Currency with no decimals.$\_\_/5$

$6.$Sort the data by Position, TeamID and Salary.$\_\_/5$