Create a workbook by the name of the Rio Olympics Medals; showing the medals tally of top four
countries.
● Make another workbook named Rio Olympics Summary, as shown below: Calculate the total
medals, country-wise using a link formula to connect the two workbooks. For example, the cell B4 of
the Rio Olympics Summary sheet should have the link formula to calculate the total of the cell range
B4 to D4 of the worksheet, Rio Olympics Medals. Repeat this for all the rows.
● Using the Maximum and Minimum functions, calculate the highest and lowest number of Gold,
Silver and Bronze medals earned by the countries. The data has to be presented in the source
workbook, in the form of a link formula, in the Rio Olympics Summary workbook.
RIO OLYMPICS MEDALS
please tell step by step
Answers
Answer:
The following medal table is a list of National Olympic Committees (NOCs) and one non-NOC team ranked by the number of gold medals won by their athletes during the 2016 Summer Olympics in Rio de Janeiro, from 5 to 21 August 2016.[1]
2016 Summer Olympics medals
Location
Rio de Janeiro, Brazil
Highlights
Most gold medals
United States (46)
Most total medals
United States (121)
← 2012 Olympics medal tables 2020 →
World map showing the medal achievements of each country during the 2016 Summer Olympics.
Legend:
Countries that won at least one gold medal.
Countries that won at least one silver medal (and no gold medals).
Countries that won at least one bronze medal (and no gold or silver medals).
Countries that did not win any medals.
Countries that did not participate in the 2016 Summer Olympics.
The number of the total medals of each country during the 2016 Summer Olympics.
Vietnam, Kosovo, Fiji, Singapore, Puerto Rico, Bahrain, Jordan, Tajikistan and Ivory Coast won their first Olympic gold medals (however, Bahrain retroactively was awarded a gold medal for the 2012 Summer Olympics in 2017 due to medals reallocation). They were also the first Olympic medals of any kind for Kosovo, Jordan and Fiji.[2][3][4][5][6][7][8][9][10][11] Kuwaiti shooter Fehaid Al-Deehani became the first independent athlete to win a gold medal,[12][13] though gold medals have been won under the Olympic flag by other entities, such as countries that competed under the flag at 1980 Summer Olympics in Moscow or the Unified Team in 1992.
The United States of America led the medal table both in number of gold medals won and in overall medals, winning 46 gold and 121 total medals respectively. Behind the United States, Great Britain were second on the medal table by golds (27) and third by overall medals (67) – their highest ranked finishes in gold since the home games of 1908 and in overall medals since 1920 – while China were third by golds (26) and second by overall medals (70). Both countries were well clear of a following group in the table that included Russia, Germany, France and 2020 host Japan.
Athletes from 87 nations earned medals at the 2016 Summer Olympics, breaking the record of most nations winning a medal at a single edition of the Olympics.[14] However, following reallocation due to doping sanctions, an 87th country was later awarded a medal at the 2008 Olympics, tying the record. Athletes from 59 nations earned gold medals at these games, also breaking the record for the most nations winning gold at a single games.[15] Host country Brazil won seven gold medals, their most at any single Summer Olympics.