Exam 5: Subtotals Pivot-tables and Pivot-charts

When formatting the data to compile a PivotTable,meaningful ________ should be used.

________ is the process of joining rows or columns of related data together into a single entity.

What is the best option for adding a calculation to a PivotTable that does not already exist?

Adding ________ to a preexisting data set can help you identify which disciplines and which areas contribute the highest revenue for a company and which disciplines and areas produce the lowest revenue.

Match the following calculated field settings with the corresponding description: I.PivotTable II.Quick Analysis gallery III.Subtotal IV.PivotTable Fields task pane V.Data mining A.The process of analyzing large volumes of data,using advanced statistical techniques,and identifying trends and patterns in the data B.A row within the dataset containing at least one aggregated value C.A method of creating a PivotTable within a worksheet D.A powerful,interactive data-mining feature that enables you to summarize and analyze data E.Contains two sections that allow for the editing of a PivotTable

After basic creation,various formatting styles can be applied to a PivotTable.

A(n)________ should be performed before subtotaling data.

To update the data in a PivotTable click ________ in the Data group.

Match the following Pivot Table move options with the corresponding description: I.Move Up II.Move Down III.Move to Beginning IV.Move to End V.Move to Report Filter A.To the end of the Report Filter area of the PivotTable B.To the end of all fields in the same area C.To the beginning of all fields in the same area D.Up one position in the hierarchy within the same area E.Down one position in the hierarchy within the same area

Which of the following is not true about a PivotChart?

Match the following terms to their meanings: I.PowerPivot II.Relationship III.Add-in IV.PivotChart V.Slicer A.A small window containing one button for each unique item in a field so that you can filter the PivotTable quickly B.An interactive graphical representation of the data in a PivotTable C.An association between two related tables where both tables contain a related field of data,such as IDs D.A built-in add-in program in Excel 2013 that enables you to import millions of rows of data from multiple data sources,create a relationship between two or more related tables within one workbook,and maintain connections E.A third party application that adds additional functionality to Excel

You must sort in order to properly execute a subtotal.

Slicer captions can be used to provide instructions to users.