What option should you select to show only specific records based on criteria?

The choice of Custom Filter is appropriate for displaying specific records based on defined criteria within a database or spreadsheet application. Custom filtering allows users to set their own rules for what data to display, facilitating the extraction of relevant information aligned with specific needs. This might involve selecting records that meet particular conditions, such as a certain date range, numerical values, or text matches.

Using Custom Filter, you can create tailored views that present only the data you are interested in, enhancing data analysis and decision-making processes. The feature is typically user-friendly, providing options to define criteria through dropdown menus and logical operations (like "greater than" or "contains").

Other options, while potentially useful for managing data presentation, do not focus specifically on filtering records based on custom criteria. For instance, Filter By Selection allows filtering based on the current selection, but it is not as flexible as a custom filter when defining multiple or complex criteria. Sorting records organizes data either in ascending or descending order rather than filtering out non-relevant data. Group By is used to aggregate data based on common fields but does not specifically filter records according to set criteria. Hence, Custom Filter is the most suitable choice for this purpose.