Question

2. Explain the concept of Filters to be applied to a worksheet.
3. Write one benefit of applying conditional formatting on data.
​

Answer 1

-Filters are added to data in a worksheet so that it becomes easier to focus on specific information from a huge database or from a table of data. When data is filtered, only the rows that meet the filter criteria will be displayed and all the other rows will be hidden.

-Conditional formatting is important for formatting cells in any data according to the requirement. It can be used for highlighting purpose, for highlighting cells, current status, and also various rows and columns and this enhances the readability of data.