solved data is attachedYour task is to select the three strikers,

data is attachedYour task is to select the three strikers, three defenders, one goalie, and one trainer who you think will be the most successful team, while staying under a total budget of $10,000. You select your players by using the drop-down lists at the top of the Players sheet. (It does not matter what order your three strikers and three defenders are in.) Macros must be enabled for this sheet to work properly.Once you have selected all of your players, enter each of your group members’ names in the blue cells in column Q, and give your team a name in the large blue cell in the first row.Save as a Excel file and explain briefly (150 words MAXIMUM) of the reasoning behind your player selections. You do not have to go into lots of detail; just let me know a few key observations or findings that informed your choices.