filtering of data is used to display only selected amount of data (a subset of data )within a cell range .true or false .
Answers
Answer:
True is your answer
Explanation:
plz mark me as a brilliant plz
Explanation:
This example teaches you how to apply an advanced filter in Excel to only display records that meet complex criteria.
When you use the Advanced Filter, you need to enter the criteria on the worksheet. Create a Criteria range (blue border below for illustration only) above your data set. Use the same column headers. Be sure there's at least one blank row between your Criteria range and data set.
And Criteria
To display the sales in the USA and in Qtr 4, execute the following steps.
1. Enter the criteria shown below on the worksheet.
Advanced Filter Example in Excel
2. Click any single cell inside the data set.
3. On the Data tab, in the Sort & Filter group, click Advanced.
Click Advanced
4. Click in the Criteria range box and select the range A1:D2 (blue).
5. Click OK.
And Criteria
Notice the options to copy your filtered data set to another location and display unique records only (if your data set contains duplicates).
Result.
And Criteria Result
No rocket science so far. We can achieve the same result with the normal filter. We need the Advanced Filter for Or criteria