Question: 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
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 6. In cell B62, enter a function to count the number of players using the data in column B. .............__/2 7. In cell E62 and J62, enter a function to automatically add up the numbers above. .......................__/2 8. 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 9. Format the values in Columns E and J as Currency with no decimals, but with commas at the thousands position. Save your worksheet......................................................................................__/2 10. Sort the data. The first sort should be by Position, Team and within that, sort by Salary.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
