Analyzing and Visualizing Data with Microsoft Excel — Question 33

You have an Excel workbook that contains a table named Sales.
You add Sales to the Power Pivot model.
You need to set a column named TransactionID as the row identifier for the Sales table.
What should you do?

Answer options

• A. From Query Editor, modify the Data Type
• B. From Power Pivot, modify the Table Behavior settings
• C. From Query Editor, add an index column
• D. From Power Pivot, modify the Default Field Set

Correct answer: B

Explanation

The correct answer is B because modifying the Table Behavior settings in Power Pivot allows you to set a specific column as the row identifier. The other options do not provide the capability to designate a row identifier; changing data types or adding an index does not achieve this objective.