Looking at this chart can anyone help me answer these following questions? a) What actions or steps in Excel can you take to rank them from 1st to 10th

b) State the specific action(s) or step(s) in Excel that will produce a list/display
of those countries with 800 or more medals in total?

c) Which type of graph will be suitable for representing only gold medals
information?

d) In which column(s) might replication have been used?

e) What Excel formula can be used to calculate the overall total medals
awarded?

14) Write the Excel functions for the following:

a. Give the total number of medals for Germany and Great Britain.

b. Give the average number of silver medals for a European country,

c. Sum the Medals Total for Gold for those countries with less than 20
games involvement.

d. Search the database (the whole spreadsheet) to find ‘Italy’ and also the
corresponding Medals Total.

15)
a) Calculate the median number of medals for each medal type, stating the
formula you would use for determining the median for the gold medals.

b) Calculate the mean number of medals for each of the 3 medal types, stating
the formula you would use for determining the mean for the bronze medals.