What steps do you take to create a filter in a spreadsheet?

• A. Activate the 'Filter' button in the toolbar only after selecting a column
• B. Right-click the column and select 'Filter by color'
• C. Type a keyword in the search box and press Enter
• D. Select "Data" from the menu and then "Create a filter," which adds a filter icon in each column header

Answer: (D)

Filtering data lets you show only the rows that meet specific criteria, which makes it easier to analyze a subset of your data. To set this up in a typical spreadsheet, you enable a filter for the data range so every column header gets a filter control. Choosing the Data menu and selecting Create a filter is the best approach because it applies to the whole dataset and adds a filter icon to each column header, enabling per-column filtering options like selecting particular values or applying conditions.

Other options don’t provide the same setup: activating a filter after selecting just one column often affects only that column or may not create the universal header controls across the table; filtering by color is a special case used only for color-based filtering; and typing a keyword in the search box is just a quick search, not a persistent filter setup for the entire dataset.