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

Computer Science & Information Technology

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

Computer Science & Information Technology

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

Computer Science & Information Technology

What is the objective of project planning?

What will be an ideal response?

Computer Science & Information Technology

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

Computer Science & Information Technology