Microsoft Excel Basic #2 - Computations on multiple columns of data

In this post, we build on Microsoft Excel Basic #1 by adding additional columns of grades.  We copy the average, minimum, and maximum grades for the class and compute the average for each student.

In the figure below, we can see that the grades of three tests are now in the spreadsheet.  The grades are in columns B, C, and D.


To copy the formulas to columns C and D, we highlight cells B8 through B10.  We left click on the square in the bottom right hand corner and drag over to column D.


Excel automatically updates the formula for columns C and D.  From the figure below, we can see that the average in column C has been automatically updated.


To compute the average for each student, we are writing a formula in column F.  For Bart, the formula is as follows:

=AVERAGE(B2:D2)


To apply the formula for all students, left click on the square in the bottom right hand corner and drag down to cell F6.  Excel will update the formula by applying the incremented row number.  The results are shown below:


Comments