60.1K

Verified Solution

Link Copied!

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 to Columns 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: CON a) Apply the validation rule to the entire column (original values in the column should be preserved). O 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 (eg. $) 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). LIC Annual Sales - 2012 Salary Sales ####### ####### ###### INN HORA Salesperson Alan Shearer 5 Bobby Charlton David Beckham 7. Gary Lineker 8. Gordon Banks 9 Kevin Keegan 10 Michael Owen 11 David Trezeguet 12 Didier Deschamps 13 Eric Cantona 14 Jean-Pierre Papin 15 Just Fontaine 16 Lilian Thuram 17 Marcel Desailly 18 Marius Tresor 19 Michel Platini 20 Patrick Vieira 21 Raymond Kopa 22 Robert Pires 23 Thierry Henry 24 Zinedine Zidane 25 Franz Beckenbauer 26 Gerd Mueller 27 Jurgen Klinsmann 28 Karl-Heinz Rummenigge 29 Lothar Matthaeus 30 Michael Ballack 31 Oliver Kahn 32 Paul Breitner 33 Sepp Maier 34 Uwe Seeler Country England England England England England England England France France France France France France France France France France France France France France Germany Germany Germany Germany Germany Germany Germany Germany Germany Gernany ### ### ####### HE RE St R RRETT R121 12 TRRRRR12 12 ## ## HORNY ####### ###### # N 35 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 to Columns 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: CON a) Apply the validation rule to the entire column (original values in the column should be preserved). O 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 (eg. $) 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). LIC Annual Sales - 2012 Salary Sales ####### ####### ###### INN HORA Salesperson Alan Shearer 5 Bobby Charlton David Beckham 7. Gary Lineker 8. Gordon Banks 9 Kevin Keegan 10 Michael Owen 11 David Trezeguet 12 Didier Deschamps 13 Eric Cantona 14 Jean-Pierre Papin 15 Just Fontaine 16 Lilian Thuram 17 Marcel Desailly 18 Marius Tresor 19 Michel Platini 20 Patrick Vieira 21 Raymond Kopa 22 Robert Pires 23 Thierry Henry 24 Zinedine Zidane 25 Franz Beckenbauer 26 Gerd Mueller 27 Jurgen Klinsmann 28 Karl-Heinz Rummenigge 29 Lothar Matthaeus 30 Michael Ballack 31 Oliver Kahn 32 Paul Breitner 33 Sepp Maier 34 Uwe Seeler Country England England England England England England England France France France France France France France France France France France France France France Germany Germany Germany Germany Germany Germany Germany Germany Germany Gernany ### ### ####### HE RE St R RRETT R121 12 TRRRRR12 12 ## ## HORNY ####### ###### # N 35

Answer & Explanation Solved by verified expert

See Answer