The Filter feature in Excel allows you to display only specific data based on a condition by hiding rows that do not meet your criteria. You can use the AutoFilter for a quick, interactive filtering experience or the newer FILTER function to dynamically filter data using a formula.
Which Excel feature allows you to display only specific data based on a condition?
Review the verified answer and explanation for this ASF Airports Security Force past-paper question on CampusFin.
Question context
This question is part of 📁 Microsoft Office within the broader 💾 Computer Science subject and appears in the ASF Airports Security Force preparation collection. Reviewing the answer together with nearby questions helps reinforce the underlying concept and identify how it may appear in competitive exams.