How would you add a date filter to a PivotTable with these fields: Date, Category, Item, Unit Price, Number Sold, and Extended Price?
A) You must use a slicer with dates. B) drag Date to the ROWS area and group it.
C) drag the Date field to the FILTERS area. D) remove Date from any PivotTable area
C
You might also like to view...
Which of the following is a double-selection control statement?
a) Do While…Loop b) For…Next c) If…Then…Else d) If…Then
When using the Spelling & Grammar button to check a document, each identified error is highlighted in a pane within the window
Indicate whether the statement is true or false
What is the objective of project planning?
What will be an ideal response?
Identify the letter of the choice that best matches the phrase or definition.
A. Displays thumbnail versions of all slides in a presentation B. Displays the screen in three sections C. Allows you to change the design and layout of notes D. Used to view a presentation within a window instead of filling the entire screen E. Displays the slide masters for the presentation