As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job.
-Ted wants to use his PivotTable to show the total value of the motorcycles for a series of motorcycle dealerships but he wants to filter the display to show only those dealers whose total stock of motorcycle is greater than $1 million.How would he accomplish this?
A) He would develop a PivotTable using the aggregate filter.
B) He would develop a PivotTable using the report filter.
C) He would develop a PivotTable using the category filter.
D) He would develop a PivotTable using the value filter.
Correct Answer:
Verified
Q85: What are the steps for sorting data
Q90: What are the guidelines for creating an
Q91: Q104: In PivotTable terminology the fields that you Q112: When related fields are grouped together in Q115: A(n)_ is an interactive table that enables Q117: The _ criteria filter requires that the Q118: The _ command automatically inserts a subtotal Q119: A(n)_ list indicates the sequence in which Q129: A(n)_ is a graphical representation of the
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