Matching
Match the following terms to their meanings:
Premises:
Subtotal
Outline
Collapse
Expand
Grouping
Responses:
A hierarchical structure of data
A row within the dataset containing at least one aggregated value
The process of joining rows or columns of related data together into a single entity
Displaying all information in a grouped data set
Restricting the view of a grouped data set
Correct Answer:
Premises:
Responses:
Subtotal
Outline
Collapse
Expand
Grouping
Premises:
Subtotal
Outline
Collapse
Expand
Grouping
Responses:
Related Questions
Q5: Connections are automatically created in PowerPivot.
Q30: What is the default summary statistic for
Q33: Once applied,slicers cannot be removed.
Q35: In a PivotTable Fields task pane,the _
Q40: A(n)_ could be used to determine the
Q48: What does the Filters Area of a
Q61: Once slicers are created additional Slicer Styles
Q69: Match each Slicer Tools command group with
Q70: Where is the command to insert a
Q106: Which of the following is not true