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.

Question

Quizplus · Accepted Answer

The Filter function allows one to display only selected rows on a list while hiding the other rows,whereas a pivot table provides summary results on groups of information.

What Is the Difference Between a Filter and a Pivot