Question

a filter rule can be created using text filters option true or false​

Answer 1

Explanation:

(also known as auto-filter) is a prime feature of Excel that allows you to extract (filter out) specific rows of data depending upon filter selection. You might need to just work with or view a smaller section of a larger data set. Filter helps you extract desired data such as data of all the student with marks greater 90%, employees belonging to Asia pacific in a multinational company and many such filter conditions-based data.

You can store the filtered data in another table (pivot table) or remove all the filters without affecting your data.