You have a sales data table with columns: Region, Salesperson, and Sales Amount. You want to create a PivotTable that shows total sales for each region.
Which step should you do first after selecting the data?
Think about how to start creating a PivotTable from your data.
To create a PivotTable, you first select your data and then go to the Insert tab and click PivotTable. Sorting or filtering is not required before creating it.
You created a PivotTable with Product in Rows and Sales Amount in Values. The default summary is SUM.
If the sales amounts for Product A are 100, 200, and 300, what will the PivotTable show for Product A?
Remember what SUM does in a PivotTable value field.
The PivotTable sums all sales amounts for Product A: 100 + 200 + 300 = 600.
You want your PivotTable to show the average sales amount instead of the sum. Which option should you choose in the Value Field Settings?
Look for the option that calculates the middle value of numbers.
Choosing 'Average' in Value Field Settings calculates the average of the sales amounts.
Your PivotTable shows sales data by month. You want to see only sales from January to March. What is the best way to filter the PivotTable?
Think about how PivotTables let you filter data without changing the source.
The Report Filter lets you select specific months to display without altering the original data.
You update the original data source by adding new sales records. After that, you open the existing PivotTable. What must you do to see the new data in the PivotTable?
Think about how PivotTables handle changes in source data.
PivotTables do not update automatically. You must click Refresh to update the data shown.