Multiple Choice
Jamie wants to use her PivotTable to show the total value of the cars for a series of car dealerships but she wants to filter the display to show only those dealers whose total stock of cars is greater than $1 million.How would she accomplish this?
A) She would develop a PivotTable using the aggregate filter.
B) She would develop a PivotTable using the report filter.
C) She would develop a PivotTable using the category filter.
D) She would develop a PivotTable using the value filter.
Correct Answer:
Verified
Correct Answer:
Verified
Q3: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB2166/.jpg" alt=" -The box that
Q32: Using Excel you can _.<br>A)store data<br>B)retrieve subsets
Q72: You use _ filters to find all
Q76: In laying out the PivotTable on the
Q78: A(n)_ is a graphical representation of the
Q78: A PivotTable summarizes data in different categories
Q79: A dark,horizontal line appears _ the column
Q82: The simplest and most convenient way to
Q83: You can access the Sort buttons in
Q126: You can use a table's sizing handle