graphc2
graphic1

Exam 77-420 Microsoft Excel 2013
1. Create and Manage Worksheets and Workbooks
1.1 Create Worksheets and Workbooks: Open Non-Native Files Directly In Excel (Access Tables)

pic1

PivotChart: See All Tables

5. Try This: Find the New Tables

Go to the PivotChart2 spreadsheet.
Select the PivotChart.
The PivotChart Tools should be available.
The Field List should be visible.

What Do You See? The Field List shows the Active Tables by default. Click on All.

There are two new Tables:
Table_tblSpecialty
Table_tblType

What Else Do You See? The Table that is linked to a database, tblProducts, has a different symbol than the two Tables which were imported into this Excel spreadsheet.

Keep going...

PivotChart Tools->Analyze->Show/Hide-> FIeld List