Question: a . Insert a PivotTable on a new worksheet based on the Orders table. b . Use Orders and Price Pivot as the name of
a Insert a PivotTable on a new worksheet based on the Orders table.
b Use Orders and Price Pivot as the name of the worksheet.
c Add the Customer field to the Rows area of the PivotTable.
d Add the Product field to the Columns area of the PivotTable.
e Add the Total field to the Values area, where it appears as Sum of Total.
f Change the Value Field Settings for the Sum of Total values to apply the Accounting number format with decimal places and the $ symbol.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
