Welcome to your free Power Query & Power Pivot in Excel test


1)

A Calendar table can be created from:



2)

To reduce the risk of Excel crashing when using Power Query and Power Pivot:



3)

To retain the formatting you apply in an Excel Pivot Table:



4)

Selecting the “Only Create Connection” option when creating a data connection to a table will:



5)

To calculate a year-to-date Sales value from your data, you could use the following DAX expression:



6)

The data in the Excel data model is stored:



7)

The values in an Excel Pivot Table are calculated by:



8)

To transfer parameters from Excel into Power Query:



9)

To create an Excel CUBEVALUE formula:



10)

To comment out a line of code in the Power Query Advanced Editor:




Be sure to click the button below to check your answers