In Excel, which of the following is an invalid option for filtering data? *
Filter by Selected Cell's Color
Filter by Selected Cell's Value
Filter by Selected Cell's Icon
None of these
Answers
Answered by
1
Filter by font color, cell color, or icon setsIn a range of cells or a table column, click a cell that contains the cell color, font color, or icon that you want to filter by.
1.On the Data tab, click Filter.
2.Click the arrow. ...
3.Under Filter, in the By color pop-up menu, select Cell Color, Font Color, or Cell Icon, and then click the criteria.
Similar questions