Question

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.

Answer 1

Answer to Q1 is option (d) our relationships were not properly defined.

In case of Pivot Table, the selection of the Source data and selection of destination data shall match exactly in the same manner. Even if there is a differnce of a single space then the Relationship among the two data does not exist , so do the outcome.

Answer to Q2 is option (b) data model.

When you are creating realtionship in pivot table, you need matching data so that its cross reference of source data in one table shall match with those of destination data in another table.

Answer to Q3 is option (a) Enable all macros.

Macros are pre-set formulas or steps for processing any functions thereto. Now, when you enable macros you give riight to process such functions and give the outcome as per the macros so pre-defined.

Answer to Q4 is option (d) Use Save As, then in Save as Type select Excel Macro-Enabled Workbook.

Its the standard procedure to save the macros enabled worksheet for future use. Else,the customised formula shall be required to be typed again as and when required.