BYSEX21C12SA
PivotTable fields can subtotal, compare, count, and perform other calculations on your data.
Correct!
Review the section "What Is a PivotTable?"
Use the PivotTable Fields pane to quickly add and remove fields by clicking or dragging.
Correct!
Review the section "Adding PivotTable Fields."
You want to modify your PivotTable to show the average inventory level instead of a sum of the inventory level. You should change the Inventory value field settings.
Correct!
Review the section "Changing Value Field Settings."
Number formatting automatically transfers from the source data to the PivotTable.
Correct!
Review the section "Formatting PivotTables."
This PivotTable is filtered by position and region.
A PivotTable showing Avg Product Sales, with Position and Last Name in the row and Region in the column. The Position filter button displays the filter symbol.
Correct!
Review the section "Filtering a PivotTable."
You are a restaurant manager. To see which menu items contribute most towards your overall revenue, create a PivotTable with Sales as a Value field and adjust the settings to display as a percentage of the grand total.
Correct!
Review the section "Show Values As."
The fields in the Values area of the PivotTable are displayed as data series on a PivotChart.
Correct!
Review the section "Creating PivotCharts."
To add a field to a PivotTable, you can:
Correct!
Review the section "Adding PivotTable Fields."
This PivotTable has the Region field added to the Rows area and the Type field added to the _____ area.
Pivot table showing Region in row, and Count of Type in column. Three regions, Central, Eastern, and Western, are listed, with various values, and there is a Grand Total row at the bottom of the PivotTable.
Correct!
Review the section "Working with PivotTables."
To simultaneously filter several PivotTables, all of which use the same source data, use:
Correct!
Review the section "Filtering a PivotTable with Slicers."
Dayna has a PivotTable with inventory items, which lists cost and markup percentages, and she needs help adding the retail price (cost multiplied by markup). What do you suggest to her?
Correct!
Review the section "Creating Calculated Fields."
If you use this PivotTable to create a PivotChart, which field will display in the legend?
PivotTable showing Sum of Amount, with Region in the Row, and Type in the Column, with three regions listed and two types listed. Various values are listed for all.
Correct!
Review the section "Creating PivotCharts."