1. When you used a data model to create a Pivot Table, you receive some errors. Which is the likely reason? Select an answer:

1. Your Pivot Table was created from an Excel table.
2. Your Pivot Table contains empty cells.
3. Your Pivot Table did not update changes to your Excel table.
4. Your relationships were not properly defined.

2. When you are creating relationships between tables, the unique values for each row are known as the _____. Select an answer:

1. index
2. data model
3. related table
4. foreign key

3. Which macro Trust Setting is not recommended unless you are absolutely certain you want to work with macros? Select an answer:

1. Enable all macros.
2. Disable all macros with notifications.
3. Disable all macros, except digitally signed macros
4. Disable all macros without notifications.

4. Once you create a macro for your Purchase Order Pivot Table, how do you save the macro? Select an answer:

1. Use Save As, then in Save as Type select Excel Macro-Enabled Workbook.
2. Ensure the file name includes Macro in the name, then click Save.
3. Ensure the file name has a .xlsx extension, then click Save.
4. Use Save As, then in Save as Type select Visual Basic Editor.