Question

A) What actions or steps in Excel can you take to rank them from 1st to 10th (4 marks)

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? (4 marks)

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

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

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


14) Write the Excel functions for the following: (5 Marks each)

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.

Answer 1

a) highlight row F by clicking on F, go to toolbar at top undar DATA click filter, you will see an arrow next to F now, click the dropdown on the arrow and sort

Step-by-step explanation: