Your PivotTable (shown below) currently has a column showing total sales for eac

Question

Your PivotTable (shown below) currently has a column showing total sales for each quarter of the year. You also want to show the total sales for the year but the annual total isn't in the base data. How would you do that? Row Labels Sum of Q1 Sum of Q2 Sum of Q3 Sum of Q4 138 51 East Maryland Virginia 136 17 119 138 20 118 227 130 97 182 North 108 North Dakota South 128 172 76 126 97 163 173 Texas West 104 437 174 127 393 144 114 California 170 235 Grand Total A PivotTable can't summarize data that isn't isn't in the underlying data source You can add a calculated field to the PivotTable. You can change the value field settings for an existing value to show the annual total. You can turn on row totals in the PivotTable design. O QUESTION 19 Relationships between tables can be stored in a data model which allows you to bring together data from multiple sources into a single PivotTable. True O False QUESTION 20 Which of the following is NOT true about PivotCharts? O PivotCharts are visual representations of the data. PivotCharts are independent of PivotTables. Changing one does not impact the other You must create a PivotTable before creating a PivotChart. You can apply chart styles to a PivotChart just like you would with a regular chart.

Explanation / Answer

18. Pivot table has a column showing total sales for each quarter, to add annual total sales data that is not present in the base data- You can add a calculated field to the Pivot table.

19. Relationships between tables can be stored in a data model which allows you to bring together data from multiple sources in a single pivot table- True

20. Not true about Pivot charts is - Pivot Charts are independent of Pivot tables.

However, from Excel 2013, you can create a Pivot chart without pivot table, hence option c) is also not true but option b) is definitely not true.

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.