Excel – Introduction to Power Pivot

What is Power Pivot?

Which button on the Power Pivot tab allows you to load and prepare data or continue working on data already added to your workbook?

Which view in the Power Pivot window allows you to drag and drop fields to create a hierarchy?

Which of the following is true about PivotTables and Power Pivot?

You can use a _______________________________ to filter data visually in a table or PivotTable.

DAX, the language of Power Pivot, stands for what?

Key performance indicators (KPIs) are visual measures of performance used to quickly assess the ____________________________ of a metric against a defined target.

Which of the following must be used to look through and calculate data over time?

When you create a calculated field, you add a new __________________ in your data source, the values of which are defined by a calculation you control.