Data Analysis with Microsoft Excel: Updated for Office 2007

10 Excel

2 Locate the folder containing your Chapter01 data fi les.

3 Double-click the Park workbook.

Excel opens the workbook as shown in Figure 1-8.

Excel Workbooks and Worksheets

Excel documents are called workbooks. Each workbook is made up of individual

spreadsheets called worksheets and sheets containing charts called chart sheets.

Opening a Workbook

To learn some basic workbook commands, you’ll fi rst look at an Excel work-

book containing public-use data from Kenai Fjords National Park in Alaska.

The data are stored in the Parks workbook, located in the Chapter01 sub-

folder of the Data folder. Open this workbook now.

To open the Park workbook:

1 Click the Offi ce button and then click Open from the Offi ce menu.

The Open dialog box appears as shown in Figure 1-7. Your dialog

box will display a different folder and fi le list.

Click to open the

currently selected

file in Excel

Display only

folders and

Excel files

Excel ribbon

Figure 1-7

The Open

dialog

box