This is a Microsoft Excel exercise that was posted on the web. It's from Professor David Houston at the University of Tennessee at Knoxville. It says it was last revised in 1999, so it's quite old. Nevertheless, it's very useful, and it has helped me learn some basic things about Excel.
This exercise requires you to make a spreadsheet with grade data for a university course.
It shows you three different methods of averaging data in cells:
- (a1+b1+c1)/3
- sum(a1:c1)/3
- average(a1:c1)
I suppose the last is the easiest, but it's nice to know the others.
The exercise also introduces the idea of the absolute reference cell. When you copy a formula from one row to the next, for example, the copy of the formula alters automatically to refer to the corresponding cells in the new row. However, if the formula contains an absolute reference, then when the formula is copied, it does not automatically adjust--the formula will still point to the same cell it did in the previous row. The way to make an absolute reference is by putting the letter (in the cell reference) in dollar signs. Like this: $A$1.
$A$1 is an absolute reference to cell A1, and no matter where a formula is copied to, it will always point back to A1.
No comments:
Post a Comment