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
- While studying for your PMP exam , you are invited to participate in a study group . At your first meeting another attendee announces that he has “ real ,
- Because computers were so expensive , computer memory was also at a premium , so system developers conserved as much memory as possible for ________ .
- Please help me with Part A.