File -> Open

Before you Begin

This example uses the same spreadsheet that was created in the previous lesson. You can continue with the one you saved or download a new sample if you wish.

 

Try This: Open a Sample Spreadsheet

Open a sample spreadsheet:

Using Named Ranges.xlsx

Go to the Original Data sheet.

 

What Do You See? This sheet shows the net product sales for three products: Legs, Eggs, and Pigs. The data includes:

 

Date (Number, formatted as Medium Date)

Product (Text)

Net (Number, formatted as Accounting)

Quantity (Number)

Revenue (Number, formatted as Accounting)

 

Memo to Self: You do not have to MATCH the numbers shown on these pages. It is more important that you begin with some data and understand the options.