2. Explain the concept of Filters to be applied to a worksheet.
Answers
Answer:
Filters are used for the purpose of easiness in the worksheet .These are usually applied for displaying of the desired data out of large worksheet . This makes easy in order just focusing on small specific data.
These filter are enable the person to filterout the numeric as well as the text data.
These are extremely helpful when you have to display only a important or main data out of a large data in meeting or research.
Read more on Brainly.in - https://brainly.in/question/1588636#readmore
Explanation:
How Filtering Works
Filters work with records or rows of data in the worksheet. The conditions you set are compared with one or more fields in the record. If the conditions are met, the record is displayed.
For example, say you're a sales manager and you want to create a program to pair your lower-performing salespeople with higher-performing ones in mentoring relationships. You could use a filter to find the highest- and lowest-performing salespeople based on their sales totals.
In this example, you would be filtering numeric data, which can be based on:
Whether the data equal a certain number
Whether the data are greater or less than a specific number
The data are above or below the average value of the data as a whole
You can also filter text data, which can be based on:
Whether the data match a certain word
Whether the data are a word containing one or more letters
Whether the data are a word that begins or ends with a specific letter of the alphabet