All of the Following Statements Are TRUE About Creating PivotTables

question 69

Multiple Choice

All of the following statements are TRUE about creating PivotTables and PivotCharts with PowerPivot EXCEPT:

• A)PowerPivot gives you the same options as a Pivot Table except you can use relational data to build it.
• B)PivotTables and PivotCharts are a major component in any dashboard.
• C)PivotTables and PivotCharts can be created with data from multiple sources without any additional software or add-ins as long as it is relational data.
• D)Not only can you create a single PivotTable or PivotChart on a worksheet with PowerPivot, but you can also create a PivotTable and PivotChart on the same worksheet as well as two PivotCharts arranged vertically or horizontally, or four PivotCharts on the same worksheet.