Question

filtering of data is used to display only selected amount of data (a subset of data )within a cell range .true or false .​

Answer 1

Answer:

True is your answer

Explanation:

plz mark me as a brilliant plz

Answer 2

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