When using Advanced Filtering on a column that contains, for example, the cost of lodgings at various places and you select the criteria shown, what will your results be?Cost is greater than 500 Or is less than 100
A) The results will contain only the cells with values over 500 and the cells with values under 100 .
B) No entries will be in the results because a value cannot be both greater than 500 and less than 100 at the same time .
C) All entries will be in the results because every cell meets at least one of the criteria .
D) Nothing will happen; this is an unacceptable filter .

Question

Quizplus · Accepted Answer

The criteria "Cost is greater than 500 Or is less than 100" will return two sets of data: one where the cost is above 500 and another where the cost is below 100, effectively filtering out costs between 100 and 500.

When Using Advanced Filtering on a Column That Contains, for Example