Question

Explain about filter. How to apply filter on data? Discuss the concept of conditional formatting.

Answer 1

Explanation:

Select any cell within the range.

Select Data > Filter.

Select the column header arrow .

Select Text Filters or Number Filters, and then select a comparison, like Between.

Enter the filter criteria and select OK.

CONDITIONAL FORMATTING

Conditional formatting is a feature in many spreadsheet applications that allows you to apply specific formatting to cells that meet certain criteria. It is most often used as color-based formatting to highlight, emphasize, or differentiate among data and information stored in a spreadsheet.