Data Analysis with Microsoft Excel: Updated for Office 2007

48 Excel Although you can type in functions directly, you may fi nd it easier to use the commands located in the Function Librar ...

Chapter 2 Working with Data 49 4 Click the Collapse Dialog button next to the number1 argument. 5 Drag your mouse pointer over t ...

50 Excel Cell References When Excel calculated the total sales for column C and column D on your worksheet, it inserted the foll ...

Chapter 2 Working with Data 51 5 SUM($C$2:$C$11) is an absolute reference to the range C2:C11. If you copied this formula into o ...

52 Excel To create range names for the service station data: 1 Select the range A1:D11. 2 Click the Create from Selection button ...

Chapter 2 Working with Data 53 All of the workbooks you’ll use in this book will contain range names for each of their data colu ...

54 Excel Sorting Data Once you’ve entered your data into Excel, you’re ready to start analyzing it. One of the simplest analyses ...

Chapter 2 Working with Data 55 EXCEL TIPS If you want to sort your list in nonnumeric order (in terms of days of the week or mon ...

56 Excel only at the night shift. A fi rm interested in salary data might want to con- sider just the subset of those making bet ...

Chapter 2 Working with Data 57 Excel opens the Custom AutoFilter dialog box. From this dialog box you can specify the criteria u ...

58 Excel 4 Click OK. Excel modifi es the list of service stations to show stations 1, 2, 6, and 9. See Figure 2-18. Figure 2-18 ...

Chapter 2 Working with Data 59 To remove the fi lters: 1 Click the Other drop-down fi lter arrow and click Clear Filter from “Ot ...

60 Excel gas sales < $8,500 and other sales < 5 $7,500. Thus, these criteria match what you created earlier using the Auto ...

Chapter 2 Working with Data 61 To create an Or condition with the Advanced Filter: 1 Delete the criteria in cell C17. 2 Enter th ...

62 Excel Using Calculated Values You decide to reward service station managers whose daily gasoline sales were higher than avera ...

Chapter 2 Working with Data 63 For more complicated formulas, you can enter the expressions using an Advanced Filter. You’ve com ...

64 Excel Having seen some of the issues involved in using a text fi le, you are ready to try importing data from a text fi le. I ...

Chapter 2 Working with Data 65 The wizard has automatically determined that the wheat.txt fi le is orga- nized as a fi xed-width ...

66 Excel 3 Click the Next button. The third step of the wizard allows you to defi ne column formats and to exclude specifi c col ...

Chapter 2 Working with Data 67 Notice that the data for the fi rst two columns appear to be cut off, but don’t worry. When Excel ...