Question

In Excel filter option is used to

• A. Edit work sheet name
• B. Display the data meet some criteria.
• C. Create new sheet
• D. Insert pictures

Answer 1

Answer:

B. Display the data meet some criteria.

The correct answer is: Display the data meet some criteria. In MS Excel, the Filter option is used to temporarily hide rows that do not meet specific conditions or criteria you set, allowing you to easily view and analyze only the data you want to see.