An average shows the total sum of several values
(amounts) divided by the number of items included to
reach the total.
For example, imagine that when you were
in school, you got six grades in your art class: 97, 89,
91, 100, 94, and 100. To find out your grade average in
your class, you would first add
all of the values or amounts:
Next, you would divide that
total by the number of
grades you added.
572 ÷ 2 = 95.3333 Rounded off to 95. Your average in
Art would be 95.
Now we'll let Excel figure our our average expenses.
cells O3 through O7, you want to find the average paid
for each bill for each month. Again, there are several ways to do this. The method we will use is the
Select cell O2. Type
Average. Select cell O3.
Click on the Insert Function button
(Excel XP) or the Paste Function button (Excel
This action lets you to choose a
function to enter in a cell. Select the function Average
from the right-hand column, as shown in the image.
Click OK. A dialog box appears. The automatic setting
should be B3:N3, indicating Excel will find the average
of cells B3 through N3 (Notice
that the colon (:) stands
Click in this space and change
the N3 to M3
(B3:M3) since we do not want the empty cell N3 to
be included in the average.
Click OK. Use the automatic copy feature to place
averages in cells O4 through O10.
Column O in your spreadsheet
should look like the model at the right
Note: The information #DIV/0! in O8 and O9 indicates division
by 0 is undefined. I would delete those.
-->>Save your spreadsheet.