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 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 .
Correct Answer:
Verified
Correct Answer:
Verified
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
Q15: The Scenario Manager window is accessed by
Q17: In a spreadsheet names can only be
Q18: To reduce the chance of messing up
Q19: Use the File menu to insert comments
Q20: A named alternative to a spreadsheet that
Q21: Filtering applies only to spreadsheets that have