Question: Question must be solved in Excel format with appropriate formulae please. Make some formatting changes to the data below, to make it a bit more
Question must be solved in Excel format with appropriate formulae please.
| Make some formatting changes to the data below, to make it a bit more pleasing on the eye | ||||
| From Club | To Club | Fee | Year | |
| Zinedine Zidane | Juventus (Ita) | Real Madrid (Spa) | 45.62m | 2001 |
| Luis Figo | Barcelona (Spa) | Real Madrid (Spa) | 37m | 2000 |
| Hernan Crespo | Parma (Ita) | Lazio (Ita) | 35.5m | 2000 |
| Gianluigi Buffon | Parma (Ita) | Juventus (Ita) | 32.6m | 2001 |
| Christian Vieri | Lazio (Ita) | Inter Milan (Ita) | 32m | 1999 |
| Andriy Shevchenko | AC Milan (Ita) | Chelsea (Eng) | 30m | 2006 |
| Rio Ferdinand | Leeds United (Eng) | Manchester United (Eng) | 29.1m | 2002 |
| Gaizka Mendieta | Valencia (Spa) | Lazio (Ita) | 29m | 2001 |
| Ronaldo | Inter Milan (Ita) | Real Madrid (Spa) | 28.49m | 2002 |
| Juan Veron | Lazio (Ita) | Manchester United (Eng) | 28.1m | 2001 |
| Rui Costa | Fiorentina [old] (Ita) | AC Milan (Ita) | 28m | 2001 |
| Pavel Nedved | Lazio (Ita) | Juventus (Ita) | 25.5m | 2001 |
| Mickael Essien | Lyon (Fra) | Chelsea (Eng) | 24.43m | 2005 |
| Didier Drogba | Marseille (Fra) | Chelsea (Eng) | 24m | 2004 |
| Nicolas Anelka | Arsenal (Eng) | Real Madrid (Spa) | 23.5m | 1999 |
| Denilson | Sao Paulo (Bra) | Real Betis (Spa) | 22m | 1998 |
| Lilian Thuram | Parma (Ita) | Juventus (Ita) | 22m | 2001 |
| Claudio Lopez | Valencia (Spa) | Lazio (Ita) | 22m | 2000 |
| Gabriel Batistuta | Fiorentina [old] (Ita) | AS Roma (Ita) | 22m | 2000 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
