Which option would clear a PivotTable filter on a State field?
A) Select the filter arrow on the Rows header and select clear filter.
B) Select the filter arrow on the Columns header and select clear filter.
C) Drag the State field off the FILTERS area.
D) Click the funnel icon to the right of the State filter and then select All and then click OK.
Correct Answer:
Verified
Q30: A PivotChart _.
A)is not altered by filters
Q31: How would you add a date filter
Q32: If you have related data stored in
Q33: Which of the following would be an
Q34: Select PivotTable styles _.
A)from the PivotTable wizard
B)from
Q36: You created a slicer on the field
Q37: Which of the following is not controlled
Q38: A(n)_ is a user-defined field that derives
Q39: If you want to turn off grand
Q40: Which category or categories display in 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