Instructions

Using the provided workbook (Experience Points Tracker), you will use your skills with and understanding of pivot tables and Excel functions to do the following:

Add a column for Rank

Use the RANK function to rank the Current Experience Points (CXP) in the Rank column

Covert the range to a table

Sort the table data based on first Rank then code name (Code)

Generate a pivot table from the table you created (make sure its on a separate worksheet)

Calculate the average CXP at the bottom of the CXP column within pivot table

Add two (2) new columns:

1) Minor XP Milestones (MinXPM) with following functionality:

Test to make sure the CXP is not negative, then

Calculate so that for every 10 CXP you get 1 MinXPM

2) Major XP Milestones (MajXPM) with the following functionality:

Test to make sure the CXP is not negative, then

Calculate so that for every 100 CXP you get 1 MajXPM

Add averages within pivot table at the bottom of the MinXPM and MajXPM columns

Rename Row Labels to Code Names and Grand Total to Averages

Be sure to name your pivot table XPTackerPivot

Special Functions Needed

To achieve the requirements of the activity, you will need to utilized functions that include:

IF statements RANK ROUNDDOWN

Link to access the excel platform:

https://moodle.lcu.edu/pluginfile.php/743568/mod_assign/introattachment/0/Experience%20Points%20Tracker.xlsx?forcedownload=1