You must carry out at least three of the following tasks but you may do more depending on time and your teacher's instructions. Task 3A Enter the following information in a new worksheet.
Enter formulae to calculate the population density for each country by dividing population by area. Produce a chart to illustrate this information. Task 3B Enter the following information in a new worksheet with countries arranged by continent.
Enter formulae to calculate Average Infant Mortality for each continent and Average Birth rate for each continent Produce a chart to illustrate this information. Task 3C Enter the following headings in a new worksheet with countries arranged by continent.
Enter statistics for each country in your sample. Enter formulae to calculate the average External Debt per continent Produce a chart showing the average external debt Europe, Asia, Africa, South America and Others Task 3D Enter the following headings in a new worksheet with countries arranged by continent.
Enter formulae to calculate the average life expectancy in each continent Produce a chart showing the average life expectancy for Europe, Asia, Africa, South America and Others Task 3E Enter the following information in a new worksheet.
Enter formulae to calculate the Trade Gap for each country by subtracting Imports from Exports Produce a chart to illustrate this information. Task 3F Enter the following information in a new worksheet.
Enter formulae to calculate percentage of GDP spent on Military by dividing Military Expenditure by GDP and formatting as a percentage. Produce a chart to illustrate this information. Task 3G Enter the following information in a new worksheet.
Enter a formula to calculate the average literacy rate and unemployment rate for each continent. Produce a chart to illustrate this information. Task 3H Produce any other appropriate worksheet and chart based on the data collected previously. |
