graphic2
graphci1

Exam 77-420 Microsoft Excel 2013
1. Create and Manage Worksheets and Workbooks
1.1 Create Worksheets and Workbooks: Add Worksheets to Existing Workbooks

Hello, Little Tables?

So, where did tblSpecialty and tblType end up? There should be two new spreadsheets. They may be Sheet2 or Sheet3.

The imported data is formatted as a Table. Each Column has a Filter.

 

4. Do This: Rename Two Sheet Tabs

Double-click the Tab for the Specialty Table.
Rename the sheet: Specialty.

Double-click the Tab for the Type Table.
Rename the sheet: Type.


Everybody remember where we parked.


Keep going...

Look at the Table Properties: The Specialty Table was named Table_tblSpecialty when it was imported. The Type Table was named Table_tblType.

Data->Get External Data->From Access

graphci3