Tables Skill Summary - Free Excel Practice Online

This free, interactive exercise teaches you Tables Skill Summary in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Tables track and works right in your browser - no Excel install, no download, and no signup.

Practising Tables Skill Summary this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.

What you'll practice in this Tables Skill Summary lesson

1. If you haven't already, download WDI Data.Note: No Excel? You can do this lesson for free in Google Sheets (File, Import, then upload the file) or in Excel for the web with a free Microsoft account. Both have pivot tables and filters, though the menus look a little different.Press Check Answer to continue.
2. Use a pivot table or column filters to answer the following questions. Of countries in Latin America & Caribbean region, which had the most visitors in 2000?
3. Of countries in Latin America & Caribbean region, in which country did 33.7% of the population have access to electricity in 2000?
4. Of countries in Latin America & Caribbean region, which had the highest GDP in 2001?
5. Of countries in Latin America & Caribbean region, which spent the highest percentage on military in 2002?
6. Of countries in Middle East & North Africa region, which had the most international tourists in 2000?
7. Each country has one row per indicator, so filter Indicator Name for one indicator too, or the same country is counted once for every indicator.Of countries in Latin America & Caribbean region, how many use the U.S. Dollar?
8. Of countries in Latin America & Caribbean region that also use the U.S. Dollar, which had the most international tourists in 2001?
9. Of countries in Latin America & Caribbean region that also use the U.S. Dollar, which had 627,000 international tourists in 2000?
10. Of ALL countries, which had 10,222,000 international tourists in 2000?

Tables Skill Summary practice - FAQ