Each filled filter is applied to equally named column. Non filled filters are ignored (rows with any value in that column are showed). AND operation is applied when multiple filters are filled (row must fit all conditions to be showed).
Only values containing entered text are showed. Text is compared case insensitive.