View the step-by-step solution to:

Switch to the worksheet "Internet user and pop. Table" .

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

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question