Question 1 of 6
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Name | Region | Sales | East names | |
| 2 | Lee | East | 800 | ||
| 3 | Patel | West | 420 | ||
| 4 | Chen | East | 610 | ||
| 5 | Ortiz | North | 150 | ||
| 6 | Kim | West | 900 |
FILTER Function - Free Excel Practice Online
This free, interactive exercise teaches you FILTER Function in Excel through 6 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 Lookup Functions track and works right in your browser - no Excel install, no download, and no signup.
Practising FILTER Function 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 FILTER Function lesson
- FILTER returns only the rows that match. Spill the East-region names with =FILTER(A2:A6,B2:B6,"East") — wait, the condition is B2:B6="East". Type =FILTER(A2:A6,B2:B6="East"). - array is the names. include is TRUE on every East row. FILTER spills Lee and Chen down from E2. The source table is not filtered in place.
- Return the whole row this time — name, region, and sales — for every East region: =FILTER(A2:C6,B2:B6="East"). - The array is now three columns wide, so FILTER spills Lee/East/800 and Chen/East/610 as a block. include still has to be one column, the same height as the array.
- Filter on a number. Keep rows where sales are greater than 500: =FILTER(A2:C6,C2:C6>500). - C2:C6>500 is TRUE for 800, 610 and 900. Patel (420) and Ortiz (150) drop out.
- AND two conditions by multiplying them. East and sales over 500: =FILTER(A2:C6,(B2:B6="East")*(C2:C6>500)). - TRUE*TRUE becomes 1, anything times FALSE becomes 0. Only Lee (East, 800) and Chen (East, 610) survive. Kim is over 500 but West.
- No South rows exist. Avoid #CALC! by passing a fallback: =FILTER(A2:A6,B2:B6="South","None"). - The third argument is if_empty. When nothing matches, FILTER returns that text instead of #CALC!. Always add it on dashboards.
- OR uses addition. East or North: =FILTER(A2:C6,(B2:B6="East")+(B2:B6="North")). - TRUE+FALSE is 1, so a row is kept if either condition is true. Lee, Chen, and Ortiz come back. West rows stay out.
FILTER Function practice - FAQ
How do I practice FILTER Function in Excel?
Open this free LogicExcel exercise and work through 6 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 FILTER Function 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 FILTER Function lesson?
This lesson covers FILTER Function as part of the Lookup Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.