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.

Transcribed Image Text:

S.No. 1 2 3 4 S 6 7 8 9 10 11 12 13 14 15 16 17 1398222222222 20 24 25 26 27 29 30 31 32 33 34 35 36 Medals Tally in Atlanta Olympics Country Algeria[ALG] Argentina[ARG] 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[GEO] Germany[GER] Great Britain GBR Greece[GRE] Hong Kong HKG] Hungary[HUN] India[IND] Indonesia|INA] Ireland[IRL] Islamic Republic of Iran[IR] Israel [ISR] Italy[ITA] Gold 2 0 1 9 0 0 0 1 2 3 3 1 3 0 1 1 9 4 2 4 1 2 1 15 0 20 1 4 1 7 0 1 3 1 0 13 Silver 0 2 1 9 1 1 1 6 2 3 7 0 11 1 0 1 8 3 1 1 0 0 2 7 0 18 8 4 0 4 0 1 0 1 0 10 Bronze 1 1 0 23 2 0 0 8 2 9 5 0 8 0 0 0 8 4 2 1 0 1 1 15 2 27 6 0 0 10 1 2 1 1 1 12 Total 3 3 **** 2 41 3 1 1 15 6 15 15 1 22 1 1 2 25 11 dulu 5 6 1 3 4 9 37 2 65 Indla 15 8 1 21 1 4 4 3 1 35 S.No. 1 2 3 4 S 6 7 8 9 10 11 12 13 14 15 16 17 1398222222222 20 24 25 26 27 29 30 31 32 33 34 35 36 Medals Tally in Atlanta Olympics Country Algeria[ALG] Argentina[ARG] 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[GEO] Germany[GER] Great Britain GBR Greece[GRE] Hong Kong HKG] Hungary[HUN] India[IND] Indonesia|INA] Ireland[IRL] Islamic Republic of Iran[IR] Israel [ISR] Italy[ITA] Gold 2 0 1 9 0 0 0 1 2 3 3 1 3 0 1 1 9 4 2 4 1 2 1 15 0 20 1 4 1 7 0 1 3 1 0 13 Silver 0 2 1 9 1 1 1 6 2 3 7 0 11 1 0 1 8 3 1 1 0 0 2 7 0 18 8 4 0 4 0 1 0 1 0 10 Bronze 1 1 0 23 2 0 0 8 2 9 5 0 8 0 0 0 8 4 2 1 0 1 1 15 2 27 6 0 0 10 1 2 1 1 1 12 Total 3 3 **** 2 41 3 1 1 15 6 15 15 1 22 1 1 2 25 11 dulu 5 6 1 3 4 9 37 2 65 Indla 15 8 1 21 1 4 4 3 1 35

Answer rating: 100% (QA)

ANSWER QUESTION 1 2 QUESTION 03 QUESTION 04 QUESTION 05 How many countries have won al... View the full answer