Question

13) please help me....


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.​

Answer 1

Answer:

1; By ranking them according to their medals that are gold, silver and bronze.

2; I don't know.

3; Bar graph.

4; In distinguish ing them by tiers of medals.

5; Addition.

14; a; 937 and 847.

b; Don't know.

c; 667

Answer 2

The answer to the given question is as follows:

a). Firstly, the RANK function in excel is used to allot the ranks then RANK.AVG is used in case the same rank is allotted to more than one in number.

b). After writing numbers in the cells, go to data validation and choose validation type 'list'.

c). Bar Graph.

d). In the column 'Total Games' and 'Gold', replication have been used.

e). By the formula, SUMPRODUCT((Ax : Ay = "___")*(Bx : Jy = "___")*(Bx : Jy)).

The Excel functions for the following:

a). The total number of medals of Germany and Great Britain are 937 and 847.

b). The average number of silver medals for European countries is 357.

c). Sum of the medals total for gold for those countries with less than 20 games involvement is 667.

d). Italy = 9th in the column, 1st in the row. Gold medals = 206, Silver medals = 178, and Bronze medals = 193.