Multiple Choice
What does the Values Area of a PivotTable do?
A) Subdivides data into one or more additional categories
B) Filters the data to display results based on particular conditions you set
C) Organizes and groups data into categories on the left side.Each group
Name occupies a single row
D) Displays summary statistics,such as totals or averages
Correct Answer:

Verified
Correct Answer:
Verified
Q120: A(n)_ is a small window containing one
Q121: Match the following terms to their meanings:
Q122: When setting custom calculation options in a
Q123: Multiple filters can be applied to a
Q124: Match the following calculated field settings with
Q126: When modifying a PivotTable,the _ appears on
Q127: A(n)_ is a powerful,interactive data-mining feature that
Q128: Which of the following tools is best
Q129: _ provide visual representations of data filters
Q130: What tool is best suited for organizing