Q. What does the FILTER function do in Excel?

A
Sorts data
B
Filters a range based on criteria
C
Counts cells
D
Formats data
Solution:

FILTER() extracts a subset of data from a range based on specified conditions.

Entri PDF Icon

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.

Entri Contact Image

Get Expert Advice for Free: Register for Your Free Consultation Now!