Multiple Choice
How would you add a date filter to a PivotTable with these fields: Date, Category, Item, Unit Price, Number Sold, and Extended Price?
A) remove Date from any PivotTable area
B) drag Date to the ROWS area and group it.
C) drag the Date field to the FILTERS area.
D) You must use a slicer with dates.
Correct Answer:
Verified
Correct Answer:
Verified
Related Questions
Q10: If you have related data stored in
Q11: Using the % of Grand Total Calculation
Q12: Match each of the following Show Value
Q13: You are analyzing sales data and eating
Q14: You can clear all fields from a
Q16: Build a PivotChart in the PivotChart wizard
Q17: What dictates the order of hierarchy of
Q18: The four areas for organizing fields in
Q19: Creating a data model in Excel is
Q20: Moving one of two fields from the