Question

How to filter for a specific value in data filtering?

• A. Data ---> Filter ----> Advanced filter
• B. Data ---> Filter ----> Auto filter
• C. Tools---> Filter ----> Advanced filter
• D. Tools---> Filter ----> Auto filter

Answer 1

Answer:

B. Data ---> Filter ----> Auto filter

DATA FILTERING

• To extract a list of unique values

              Data ---> Filter ----> Advanced filter

• To filter for a specific value

               Data ---> Filter ----> Auto filter

• To circle invalid data in a worksheet

               Tools ----> Formula Auditing -----> Show Formula

               Auditing toolbar -----> Click Circle Invalid Data button.