Data Analysis with Microsoft Excel: Updated for Office 2007
68 Excel 6 Click the Save button. 7 Click the Offi ce button and then click Close to close the workbook. Importing Data from Dat ...
Chapter 2 Working with Data 69 To see how this works, you’ll import another data set containing nutri- tional data located in an ...
70 Excel Now that you’ve started the Query Wizard, you are free to select the vari- ous fi elds that you’ll import into Excel. T ...
Chapter 2 Working with Data 71 4 Click the Next button. After specifying which fi elds you’ll import, you’ll now have the opport ...
72 Excel Figure 2-27 Selecting only those records whose price >= $1.25 This criterion selects only those records whose price ...
Chapter 2 Working with Data 73 3 Click the Next button. The last step in the Query Wizard is to choose where you want to send th ...
74 Excel formatted the data values in a table and added AutoFilter buttons to fi lter the data if you so desire. Figure 2-29 Dat ...
Chapter 2 Working with Data 75 3 Click the Offi ce button and then click Close. 4 Click the Offi ce button and then click Exit E ...
76 Excel Table 2-7 Soft Drink Sales Data Brand Cases2000 Cases2001 Cases2002 Origin Coca-Cola 3198.0 3189.6 3288.9 1886 Pepsi 21 ...
Chapter 2 Working with Data 77 a. Enter the data from Table 2-8 into a blank workbook and save the work- book as Big Ten Graduat ...
78 Excel c. Create range names for all of the col- umns in the worksheet. d. Sort the data in ascending order of the Ratio colum ...
Chapter 2 Working with Data 79 e. Remove the fi lter, displaying all val- ues in the workbook again. f. Add a new column to the ...
80 Excel a. Open the Cars workbook from the Chapter02 folder. b. Create range names for all of the data columns you retrieved. U ...
81 Chapter 3 WORKING WITH CHARTS Objectives In this chapter you will learn to: Identify the different types of charts created by ...
I n Chapter 2, you learned how to work with data in an Excel worksheet. In this chapter you’ll learn how to display those data w ...
Chapter 3 Working with Charts 83 It’s diffi cult to answer those questions by examining the table. Now let’s plot those values i ...
84 Excel Excel includes variations of each of these chart types. For example, the column charts can display values across catego ...
Chapter 3 Working with Charts 85 chart sheets, which appear as separate sheets in the workbook. Figure 3-2 shows examples of bot ...
86 Excel Introducing Scatter Plots In this chapter, we’ll examine athletic graduation rates for a group of uni- versities. The B ...
Chapter 3 Working with Charts 87 Figure 3-3 The Big Ten workbook 2 Save the fi le as Big Ten Graduation Chart. A school with a l ...
«
1
2
3
4
5
6
7
8
9
10
»
Free download pdf