Question

In addition to sorting and filtering cells by content you can sort and/or filter by

A) Top/Bottom rules
B) conditional formatting.
C) icon sets
D) the data bar

Answer 1

B. Conditional formatting.

Step-by-step explanation:

Microsoft Excel is a spreadsheet application with tools to analyse and clean data. Filtering and sorting data in a cell or column can be done in varieties of ways including conditional formatting.

Conditional formatting is an analysis tool found on the data tab in the ribbon. It formats a group of data that meets a condition with a specified format ( color, icon, coloured Icon etc).