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...

Modern file systems use what component to describe information about files, such as time stamps and file attributes?

A. File naming conventions B. Hierarchical organization C. Data storage methods D. Metadata

Computer Science & Information Technology

TIFF stands for:

a. Transitional Image File Format b. Total Inclusion File Format c. Tagged Interchange File Format d. Temporary Instruction File Format e. Table Index File Format

Computer Science & Information Technology