Multiple Choice
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 And is less than 100
A) No entries will be in the results because a value cannot be both greater than 500 and less than 100 at the same time .
B) The results will contain all the cells with values over 500 and the cells with values under 100 .
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 .
Correct Answer:
Verified
Correct Answer:
Verified
Q4: What method is used to access subsets
Q5: The two basic principles for setting up
Q6: Fonts should be clear in a spreadsheet
Q7: The Scenario Manager offers a _ which
Q8: If you use multiple criteria in a
Q10: Summary information should be placed at the
Q11: A word or phrase assigned to a
Q12: Descriptive information should be placed<br>A) on the
Q13: Computer scientists say it is better to
Q14: The advanced filtering technique allows you to