Given below is a range of a spread sheet showing the number of gold, silver and bronze medals won by each of the countries which participated in Atlanta Olympics. The table is arranged in alphabetical order of country names. Incorporate the necessary formulae and design the necessary operations in the spreadsheet to answer the following questions or perform the tasks stated:

1. Re-organize the data in the table according to descending order of number of gold medals; if there is a tie, use the number of silver medals for tie-breaking; if there is a further tie, use number of bronze medals; then finally, total number of medals. If the tie still remains unbroken, break it randomly.

2. Suppose the rank of a country is determined using the above rule. Countries with the same number of medals in each category should be ranked the same. Create a separate field for the rank of each country and determine the ranks. Is it possible to determine the ranks without actually sorting the data as mentioned above? Suppose the ranks are generated by treating one gold medal as equal to 4 silver medals, or 10 bronze medals. Using the same rule, one silver medal becomes equal to 2.5 bronze medals. What would be the new ranking as per this rule?

3. In a cell(s) of your choice, show the name of the country or countries with the maximum number of gold medals. Similarly, show in separate cells the names of countries with the maximum number of silvers and bronzes.

4. Classify the countries according to the continent to which they belong: Asia, Australia, Europe, Africa, North America, and South America. Generate the medal tally for each continent.

5. How many countries have won all three categories of medals?

6. List the names of countries each of which has won at least 5 gold medals and at least a total of 20 medals. Develop a two way table by varying the above two values (that is at least 6 gold medals and at least 21 total number etc.)

7. According to a hypothesis, the countries with top position in gold medals, do not rank high in bronze medals. Does the above data support this hypothesis?

8. Build a feature in the spreadsheet such that the color of the font for the country names changes as follows: A. red, if the country has a single digit total, B. blue, if the country has no gold nor silver and has single digit number of bronze medals, and C. green, if the country has a rank of less than or equal to ten.

Medals Tally in Atlanta Olympics S.No. Gold 2. Silver 0 Bronze 1 Total 3 1 2 3 0 2 1 3 1 1 2. 4 9 9 0 23 2. 41 5 0 1 3 6 0 1 0 1 7 0 1 0 1 8 1 6 8 15 2 2. 3 2 9 6 15 10 3 11 3 7 5 WWW 15 1 12 1 0 0 8 13 3 11 22 14 0 1 0 1 15 1 0 0 1 16 1 1 0 2 9 8 8 25 17 18 Country Algeria ALG] Argentina ARGI Armenia(ARM) Australia (AUS) Austria AUT) Azerbaijan(AZE] Bahamas BAH] Belarus BLR) Belgium(BEL) Brazil(BRA Bulgaria(BUL) Burundi BDI) Canada(CAN) Chinese Taipei TPE) Costa Rica CRC) Croatia[CRO] Cuba CUB] Czech Republic (CZE) Democratic People's Republic of Korea(PRK) Denmark DEN Ecuador(ECU) Ethiopia ETH] Finland (FIN) France[FRA] Georgia GEO1 Germany GER] Great Britain GBR) Greece(GRE) Hong Kong HKG) Hungary(HUN) India(IND) Indonesia[INA] Ireland [IRL] Islamic Republic of Iran(IRI Israel ISR] Italy (ITA) 3 4 11 19 2 1 2 S 20 4 1 1 21 1 0 0 1 2 0 1 3 22 23 1 4 2 7 1 15 24 15 37 25 0 0 2 2 26 20 18 27 65 27 1 8 6 15 8 28 4 4 0 29 1 0 0 1 7 4 10 21 1 0 0 1 30 31 32 33 1 1 2 4 3 1 4 34 1 1 1 3 35 0 0 1 1 36 13 10 12 35 3 6 37 38 1 3 2 5 6 14 39 3 4 4 11 40 1 4 3 8 41 7 15 5 1 42 43 0 0 0 1 27 1 1 0 44 0 1 1 2 1 45 0 0 1 46 0 1 0 0 1 2 47 0 2 48 0 0 1 1 0 2 0 2 49 SO 4 S 19 10 1 51 3 2 6 S2 2 1 3 6 S3 2 2. 7 50 54 16 22 3 12 0 5 1 Jamaica JAM] Japan (JPN) Kazakhstan(KAZ] Kenya KEN) Korea(KOR) Latvia/LAT Lithuania LTU Malaysia MAS] Mexico MEX] Mongolia MGL] Morocco MAR] Mozambique MOZ Namibia[AM] Netherlands NED] New Zealand NZL] Nigeria NGR] Norway NOR] People's Republic of China(CHN) Philippines[PHI] Poland(POL) Portugal POR] Puerto Rico[PUR] Republic of Moldova MDA] Romania ROM] Russian Federation(RUS) Slovakia SVK) Slovenia SLO] South Africa RSA) Spain (ESP) Sweden (SWE) Switzerland SUI] Syrian Arab RepublicSYR] Thailand THA) Trinidad and Tobago (TRI) Tunisia TUNI Turkey TUR Uganda UGA) Ukraine (UKR) United States of America 55 56 0 7 1 17 S S7 1 0 1 2 58 0 0 1 1 59 0 1 1 2 60 4 7 9 20 63 61 26 21 16 62 1 1 1 63 0 2 0 3 2 5 17 64 1 1 3 S 65 6 6 66 2 4 2 8 4 3 0 7 1 0 0 1 67 68 69 70 1 0 2 2 0 1 2 1 0 0 0 71 72 4 1 1 1 6 1 23 73 0 0 9 1 12 74 2 75 44 32 25 101 76 0 77 Unknown Uzbekistan(UZB] Yugoslavia[YUG] Zambia[ZAM] 0 1 1 1 0 1 2 2 4 78 79 0 1 0 1 Medals Tally in Atlanta Olympics S.No. Gold 2. Silver 0 Bronze 1 Total 3 1 2 3 0 2 1 3 1 1 2. 4 9 9 0 23 2. 41 5 0 1 3 6 0 1 0 1 7 0 1 0 1 8 1 6 8 15 2 2. 3 2 9 6 15 10 3 11 3 7 5 WWW 15 1 12 1 0 0 8 13 3 11 22 14 0 1 0 1 15 1 0 0 1 16 1 1 0 2 9 8 8 25 17 18 Country Algeria ALG] Argentina ARGI Armenia(ARM) Australia (AUS) Austria AUT) Azerbaijan(AZE] Bahamas BAH] Belarus BLR) Belgium(BEL) Brazil(BRA Bulgaria(BUL) Burundi BDI) Canada(CAN) Chinese Taipei TPE) Costa Rica CRC) Croatia[CRO] Cuba CUB] Czech Republic (CZE) Democratic People's Republic of Korea(PRK) Denmark DEN Ecuador(ECU) Ethiopia ETH] Finland (FIN) France[FRA] Georgia GEO1 Germany GER] Great Britain GBR) Greece(GRE) Hong Kong HKG) Hungary(HUN) India(IND) Indonesia[INA] Ireland [IRL] Islamic Republic of Iran(IRI Israel ISR] Italy (ITA) 3 4 11 19 2 1 2 S 20 4 1 1 21 1 0 0 1 2 0 1 3 22 23 1 4 2 7 1 15 24 15 37 25 0 0 2 2 26 20 18 27 65 27 1 8 6 15 8 28 4 4 0 29 1 0 0 1 7 4 10 21 1 0 0 1 30 31 32 33 1 1 2 4 3 1 4 34 1 1 1 3 35 0 0 1 1 36 13 10 12 35 3 6 37 38 1 3 2 5 6 14 39 3 4 4 11 40 1 4 3 8 41 7 15 5 1 42 43 0 0 0 1 27 1 1 0 44 0 1 1 2 1 45 0 0 1 46 0 1 0 0 1 2 47 0 2 48 0 0 1 1 0 2 0 2 49 SO 4 S 19 10 1 51 3 2 6 S2 2 1 3 6 S3 2 2. 7 50 54 16 22 3 12 0 5 1 Jamaica JAM] Japan (JPN) Kazakhstan(KAZ] Kenya KEN) Korea(KOR) Latvia/LAT Lithuania LTU Malaysia MAS] Mexico MEX] Mongolia MGL] Morocco MAR] Mozambique MOZ Namibia[AM] Netherlands NED] New Zealand NZL] Nigeria NGR] Norway NOR] People's Republic of China(CHN) Philippines[PHI] Poland(POL) Portugal POR] Puerto Rico[PUR] Republic of Moldova MDA] Romania ROM] Russian Federation(RUS) Slovakia SVK) Slovenia SLO] South Africa RSA) Spain (ESP) Sweden (SWE) Switzerland SUI] Syrian Arab RepublicSYR] Thailand THA) Trinidad and Tobago (TRI) Tunisia TUNI Turkey TUR Uganda UGA) Ukraine (UKR) United States of America 55 56 0 7 1 17 S S7 1 0 1 2 58 0 0 1 1 59 0 1 1 2 60 4 7 9 20 63 61 26 21 16 62 1 1 1 63 0 2 0 3 2 5 17 64 1 1 3 S 65 6 6 66 2 4 2 8 4 3 0 7 1 0 0 1 67 68 69 70 1 0 2 2 0 1 2 1 0 0 0 71 72 4 1 1 1 6 1 23 73 0 0 9 1 12 74 2 75 44 32 25 101 76 0 77 Unknown Uzbekistan(UZB] Yugoslavia[YUG] Zambia[ZAM] 0 1 1 1 0 1 2 2 4 78 79 0 1 0 1