Matching
Match the filter options to their explanations:
Premises:
Filtering
Duplicate Values
Top 10 option
Sorting
Custom Filter
Responses:
conditional formatting that displays doubled cells
specify a number or percentage of records to display
arranges records in a table by the value
displays only records that meet conditions
complex filtering requirements
Correct Answer:
Premises:
Responses:
Filtering
Duplicate Values
Top 10 option
Sorting
Custom Filter
Premises:
Filtering
Duplicate Values
Top 10 option
Sorting
Custom Filter
Responses:
Related Questions
Q5: You can sort data by one or
Q19: Each row in an Excel table<br>A) is
Q44: If the automatic page breaks occur in
Q74: Why might you want to freeze rows
Q75: What are the four types of sorts
Q77: A color scale:<br>A)highlights cells meeting specified criteria
Q78: Top/Bottom Rules:<br>A)is a horizontal gradient or solid
Q81: What is a field?<br>A)A complete set of
Q83: How can you identify the difference between
Q84: Each column in a table:<br>A)needs to be