Just the formulas please!

range of cells ex: A$3$:A$122$

$10.$ Use an Excel function to determine how many countries are in Africa

$($Continent$).(1$ mark$)$

$15.$ Use an Excel function to determine how many countries are not in Asia. $(1$

mark$)$ Note: The comparison symbol for not is

$17.$ Use an Excel function to determine how many countries have a population

greater than and equal to $5\mathrm{.}8$ million and a Land Area of less than $500000.$

$(2$ marks$)$

$18.$ Use the Excel function to calculate the Total Population of Asia and African

countries. $(3$ marks$)$

Hint: This question requires using two Excel formulas $($sumifs$)$ to find the

answer. The first sumifs function finds the Population in Asia, and the

second sumifs function finds the Population in Africa, to add both values.

eg$.=$sumifs$()+$sumifs$()$

$19.$ Use an Excel function to determine how many countries have a population

between $10$ million and $200$ million. $(2$ marks$)$

$20.$ Use an Excel function to calculate the average Trade Balance for countries

in Asia with a negative Trade Balance, Median Age between $25$ and $46,$

and World Share greater than $0\mathrm{.}15\%.(3\mathrm{.}5$ marks$)$

$21.$ Use the Excel function to calculate the following

a$)$ Total Population $(0\mathrm{.}5$ marks$)$

b$)$ Average of Population $(0\mathrm{.}5$ marks$)$

c$)$ Median of Population $(0\mathrm{.}5$ marks$)$

d$)$ The variance of Median Age $(0\mathrm{.}5$ marks$)$

e$)$ The standard deviation of Median Age $(0\mathrm{.}5$ marks$)$