Hello, XML Data Table

4. What Do You See? The XML data will be displayed as a Table in Microsoft Excel. There are filters in the top row on the fields.
 

What Else Do You See? The Table Tools should be available. On the Design Ribbon you should see two useful Groups:

 

Tools: for PivotTables or Remove Duplicates 
External Table Data: to Export or Refresh the External Data.

 

Keep going...

Table Tools ->Design

Exam 77-888: Microsoft Excel Expert 2010

1. Sharing and Maintaining Workbooks

1.1. Apply workbook settings, properties, and data options: Import XML data