Microsoft Office Tutorials and References
In Depth Information
Validation Rules AC 177
2
Click the Total row in the
Commission column to display
an arrow.
Click the arrow to display a
menu of available computations
(Figure 3–55).
Will I always get the same list?
No. You only will get the items
that make sense for the type of
data in the column. You cannot
calculate the sum of text data, for
example.
Total row arrow
no calculation
Total row for
Commission fi eld
calculate sum
calculate average
3
Click Sum to calculate the sum of
the commissions.
count records
fi nd largest value
fi nd smallest value
calculate standard
deviation
available
computations
calculate variance
Figure 3–55
4
Click the Total row in the Rate
column to display an arrow.
Totals button
Click the arrow to display a menu
of available computations.
Click Average to calculate the
average of the rates (Figure 3–56).
I
Experiment
Experiment with other statistics.
When fi nished, once again
select the sum of the commissions
and the average of the rates.
total of
commissions
average
of rates
Figure 3–56
 
Search JabSto ::




Custom Search