Question

How to extract a list of unique values?

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

Answer 1

Answer:

A. Data ---> Filter ----> Advanced 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.