Switch to the worksheet "Internet user and pop. Table". Use a VLOOKUP function in cell F2 so that it searches for the country in A2 (of current worksheet) that also appears within the "2016" worksheet and display its number of internet users. Expand the formula down to find the number of internet users for each country. (Be sure to use relative and absolute cell references as needed.)
In the cell G2, use a similar VLOOKUP function to display the population for that country. Expand the formula down to find the population for each country.
In cell J2, use a formula to calculate the % of the population that uses the internet. Use the same calculation for each country.
Recently Asked Questions
- Do all eggs have an animal pole and a vegetal pole? Or is it just the amphibian eggs that contain a lot of yolk?
- what is the purpose Excel 2016 Essential Training, and what can be learnt from it
- 1) Do employees have to join a union to work with your company? 2) Can employees form a union? 3) Why should a business maintain good