0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
What is the term for the process of dynamically rearranging a PivotTable?
Pivoting
What is the default summary function for numeric data in a PivotTable?
SUM
When a numeric field is added to a pivottable is is placed in the?
Values Area
Which tab of the PivotTable Tools Ribbon contains the command to sort cells in your PivotTable?
The Sort & Filter button is in the Editing group on the Home Tab.
What is areas of a PivotTable Report where fields can be placed?
database, field and criteria
When a nonnumeric field is added to a PivotTable it is placed in the?
column labels
What does not delete a pivot chart?
Deleting a PivotTable does not delete a PivotChart. Instead, by doing this, you create a chart that cannot be changed.
Which PivotTable report area allows you to display only certain data using a list arrow?
Report Filter
What is private table?
The Clear All command is not visible when the worksheet that contains the PivotTable report is protected. The Clear All command does not work if you protect the worksheet and then select the Use PivotTable Reports check box in the Protect Sheet dialog box because the Clear Allcommand requires a refresh operation.
What must you do in the PivotTable report to bring it up to date after you change the source of information?
Refresh data
How to create Pivot Table in Excel?
Create a PivotTable to analyze worksheet data Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web More... You on hurry! Watch this video A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. PivotTables work a little bit differently depending on what platform you are using to run Excel.
How do you find what sheet or where the data came from in an Excel pivot table?
Excel 2007:Click on any cell of Pivot table.Click on the Options Tab for PivotTable Tools.In the Data section, click on Change Data Source icon, then the Change Data Source item from the drop-down menu.Observe the Table/Range in the Change PivotTable Data Source window.Excel 2003:Click on any cell of Pivot table.Open the Data menu and select Pivot Table.In Pivot Table Wizard use Back button and change address of the source data.
