Unformatted text preview: Short Tutorial on the Use of Excel 2007 9/14/2008 A) Calculating the average in Excel Each small box in the Excel spreadsheet is called a cell. Cell D5 is selected in the figure: Enter your data into one of the columns. In this example, the data are in cells C3‐C10. To calculate the average of these values, select an empty cell and type: =AVERAGE(“first cell”:”last cell”) Be sure to type the cell name of the first and last cell containing your data. In this example you would type: =AVERAGE(C3:C10) Then hit enter Alternatively you could type: =AVERAGE( Then use your mouse to sele...
View Full Document
- Spring '08
- Physics, cell. Cell D5, select add trendline