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.
Answer: D
You might also like to view...
Describe the processes associated with data extraction, cleansing, and transformation tools.
What will be an ideal response?
Use the Windows ________ to exit out of a nonresponsive program
Fill in the blank(s) with correct word
The Disk Defragmenter uses the color ________ to highlight unmovable files on your disk
Fill in the blank(s) with correct word
In the accompanying figure of Windows 10, Box A is pointing to theshortcut menu that appears when you_____.
?
?
A. ?cut and paste a folder on the same drive B. ?drag a folder using the right mouse button C. ?cut and paste a folder on a different drive D. ?drag a folder using the left mouse button