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
Q100: The entry 20000 is the _ for
Q109: The second sort field in a sort
Q111: When you want to see all the
Q113: Typically you want to sort by the
Q117: The _ criteria filter requires that the
Q118: The _ command automatically inserts a subtotal
Q119: A(n)_ list indicates the sequence in which
Q124: Jamie wants to be able to analyze
Q127: Separate the data (including the header row)from
Q133: Critical Thinking Case-Based Questions
Case 5-3
As she prepares
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents