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.

This problem has been solved! see the answeran evil king has a cellar containing n bottles of expensive wine, and his guards have just caught a spy trying to poison the king’s wine. fortunately, the guards caught the spy after he succeeded in poisoning only one bottle. unfortunately, they don’t know which one. to make matters worse, the poison the spy used was very deadly; just one drop diluted even a billion to one will still kill someone. even so, the poison works slowly; it takes a full month for the person to die. design a scheme that allows the evil king to determine exactly which one of his wine bottles was poisoned in just one month’s time while expending at most o(logn) of his taste testers.you are not allowed to use n testers, one for each bottle, and see which one tester dies after 30 days.(no pseudocode needed. just answer in words, how many testers you use, how you use them and why you correctly identify the poisoned bottle in 30 days)

in 2007, floridians died in alcohol-related collisions.a.  501b.  1,051c.  5,015d.  10,839

The guy wire bd exerts on the telephone pole ac a force p directed along bd. knowing the p must have a 720-n component perpendicular to the pole ac, determine the magnitude of force p and its component along line ac.