What is a benefit of Power Pivot versus standard Pivot Tables?

a) Power Pivot has no data limit, where PivotTables are limited to just over 1 million records.

b) Power Pivot can be used without Excel, where PivotTables requires Excel.

c) Power Pivot works with ALL versions of Excel, where PivotTables only works with certain versions of Excel.

d) Power Pivot uses ALL the same functions as Excel so there is no learning curve.

What is one of the advantages of adding data to the Power Pivot data model versus adding it to an Excel worksheet?

a) Data in the data model can be changed.

b) Data in the data model cannot be changed.

c) Data changed in the data model also changes it in the source data.

d) It is the only way to create PivotTables to analyze data.

Answer rating: 100% (QA)

The correct answer to the first question is a Power Pivot ha... View the full answer