Question 1 of 10
Rather than using a pivot table, return to the "Data" tab of the workbook.
Note: If you don't have Excel, you can follow along on this version, though some functionality may be a bit different.
Press Check Answer to continue.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 |
Table Filters - Free Excel Practice Online
This free, interactive exercise teaches you Table Filters 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 Table Filters 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 Table Filters lesson
- If you haven't already, download WDI Data.Rather than using a pivot table, return to the "Data" tab of the workbook.Note: If you don't have Excel, you can follow along on this version, though some functionality may be a bit different.Press Check Answer to continue.
- Move the cursor to row 1 and hold Shift+Space to highlight the entire row. Then press and release Alt, A, T (or click Data, then click Filter) to filter the columns. A button with a triangle should now appear in each column heading which reveals a drop-down menu when clicked.Press Check Answer to continue.
- Click the filter drop-down in the Currency column and un-check "Select All." Check the box for Euro and click ok. Similarly, filter Indicator Name for Military Expenditure.Click the filter drop-down in the 2000 header and click "Sort Largest to Smallest."Which Euro country spent the highest percentage on military in 2000?
- Now sort 2003 largest to smallest.Which Euro country spent the highest percentage on military in 2003?
- Click the Currency filter and check "Select All." Filter Region for "East Asia & Pacific."Which country in East Asia & Pacific region spent the highest percentage on military in 2001?
- Change the "Indicator Name" filter to International Tourism.Which country in East Asia & Pacific region had the FEWEST visitors in 2004?
- How many countries are in the East Asia & Pacific region AND use the U.S. Dollar?
- Of the countries that are in the East Asia & Pacific region AND use the U.S. Dollar, which had the MOST visitors in 2000?
- Of the countries that are in the East Asia & Pacific region AND use the U.S. Dollar, which had 5200 visitors in 2000?
- Of the countries that are in the East Asia & Pacific region AND use the U.S. Dollar, which had 44000 visitors in 2000?
Table Filters practice - FAQ
How do I practice Table Filters in Excel?
Open this free LogicExcel exercise and work through 10 interactive steps. You type the real formula into a live spreadsheet grid and get instant feedback on whether it is correct, plus an explanation - no Excel install and no signup needed.
Is the Table Filters exercise free?
Yes. Every LogicExcel exercise is 100% free with no account required. Your progress saves automatically in your browser.
What will I learn in this Table Filters lesson?
This lesson covers Table Filters as part of the Tables track. You practice the syntax step by step until it becomes muscle memory you can use at work.