7. For each of the following statements, write the conditional formulae to be typed in Excel which will provide the answer. a) Add up all the gold medal winnings of those NOCs whose names begin with an S. b) Find the average gold medal winnings of those NOCs who have been awarded fewer than ten bronze medals. c) Count the number of those NOCs that have been awarded ten or more silver medals.

Order National Olympic Gold Silver Bronze Total Norway 16 13 37 2 Germany 12 10 27 People's Republic of China 4 15 4 United States of America 25 5 Sweden 18 Netharlands 17 Austria 18 Switzerland 14 9 ROC 14 32 10 France 14