Multiple Choice
What is the difference between a Filter and a pivot table?
A) A Filter requires that rows are sorted by a column or group before they are analyzed;a pivot table does not.
B) A Filter can analyze dissimilar information;a pivot table cannot.
C) A pivot table provides summary results on groups of information;a Filter shows only rows in some group.
D) A pivot table provides more detailed information than a Filter.
Correct Answer:

Verified
Correct Answer:
Verified
Q8: Conditional formatting highlights the information in a
Q9: A list is created by the sales
Q10: A list often contains blank rows to
Q11: Goal Seek works backward from an objective
Q12: Conditional formatting from a list can be
Q14: Basic Filter allows you to choose to
Q15: Which spreadsheet feature would allow one to
Q16: A newly formed company producing glass paperweights
Q17: A(n)_ is a collection of information arranged
Q18: _ allows you to hide all the