Data Analysis with Microsoft Excel: Updated for Office 2007

8 Excel The menu commands below the Offi ce button are used to set the proper- ties of your Excel application and entire Excel d ...

Chapter 1 Getting Started with Excel 9 1 Press CTRL+n to create a new blank document. I Click the Copy button from the Clipboard ...

10 Excel 2 Locate the folder containing your Chapter01 data fi les. 3 Double-click the Park workbook. Excel opens the workbook a ...

Chapter 1 Getting Started with Excel 11 A single workbook can have as many as 255 worksheets. The names of the sheets appear on ...

12 Excel Table 1-3 Workbook Navigation Buttons Button Image Purpose First sheet Scroll to the fi rst sheet in the workbook Previ ...

Chapter 1 Getting Started with Excel 13 The form that appears in this worksheet resembles the form used by the Kenai Fjords staf ...

14 Excel Clearly, the Park workbook is complex. Its sheets contain many pieces of information, much of it interrelated. This boo ...

Chapter 1 Getting Started with Excel 15 To select a cell from the worksheet: 1 Click the Total Usage sheet tab to move back to t ...

16 Excel 3 With the CTRL key still pressed, select the range F4:F17. The selected range is shown in Figure 1-12. The cell refere ...

Chapter 1 Getting Started with Excel 17 3 Drag the selected area down two cells, so that the new range is now B6:F19, and releas ...

18 Excel Printing from Excel It would be useful for the chief of interpretation at Kenai Fjords National Park to have a hard cop ...

Chapter 1 Getting Started with Excel 19 Table 1-4 describes the variety of options available to you from the Print Preview tab i ...

20 Excel 6 Click the OK button. Header dialog box Figure 1-14 Adding a header to the printed page Page Setup button Page Setup d ...

Chapter 1 Getting Started with Excel 21 Figure 1-15 Landscape orientation of the printed page custom header landscape orientatio ...

22 Excel default printer specify what parts of the workbook to print Figure 1-16 Print dialog box open the Print Preview window ...

Chapter 1 Getting Started with Excel 23 So that you do not change the original fi les (and can go through the chap- ters again w ...

24 Excel Excel then saves the workbook under the name Park Usage Report. Note that if you can save the workbook under a variety ...

Chapter 1 Getting Started with Excel 25 3 Click the Manage list box at the bottom of the window, select Excel Add-Ins and then c ...

26 Excel Figure 1-19 List of currently available add-ins click to browse for an add-in file Each available add-in is shown in Fi ...

Chapter 1 Getting Started with Excel 27 Figure 1-20 The StatPlus add-in StatPlus add-in installed and activated 8 Click the OK b ...