Tasks: In the Sales-Data worksheet: 1. Break the data in the Salesperson column into two columns: First Name and Last Name. (Use the Text t feature in the Data tab). Make sure that you also type the column labels First Name and Last Name. 2. Add a validation to the country column so the only valid entries include England, France or Germany. The following criteria should be considered while applying the validation rule: a) Apply the validation rule to the entire column (original values in the column should be preserved). b) Add a user-friendly Error Alert (notifying users in case they try to enter an invalid value for country). c) Add an input message to inform users which countries are valid. 3. Format the worksheet to make it aesthetically pleasing and include measurement units (e.g. $) 4. Sort the data by country and by last name of salesperson within each country. 5. Create subtotals by Country showing: a) Totals for Salary and Sales b) Averages for Salary and Sales 6. Label the subtotals appropriately (if needed). Michel Platini France Patrick Vieira France Raymond Kopa France Robert Pires France Thierry Henry France Zinedine Zidane France Franz Beckenbauer Germany Gerd Mueller Germany Jurgen Klinsmann Germany Karl-Heinz Rummenigge Germany Lothar Matthaeus Germany Michael Ballack Germany Oliver Kahn Germany Paul Breitner Germany Sepp Maier Germany Uwe Seeler Germany 79,000 602,645 37,000 738,052 76,000 822,211 80,000 304,211 61,000 622,240 33,000 190,037 66,000 314,437 71,000 854,398 74,000 391,346 67,000 626,119 71,000 374,572 39,000 180,504 56,000 640,261 20,000 869,937 59,000 256,754 54,000 665,744 Annual Sales - 2012 Salesperson Alan Shearer Bobby Charlton David Beckham Gary Lineker Gordon Banks Kevin Keegan Michael Owen David Trezeguet Didier Deschamps Eric Cantona Jean-Pierre Papin Just Fontaine Lilian Thuram Marcel Desailly Marius Tresor Country England England England England England England England France France France France France France France France Salary 60,000 34,000 39,000 23,000 85,000 83,000 40,000 34,000 78,000 30,000 22,000 63,000 78,000 42,000 54,000 Sales 489,817 844,935 766,277 330,707 700,950 334,433 190,508 461,193 232,273 419,128 775,294 567,230 371,064 643,445 590,275