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 ﬁ eld

calculate sum

calculate average

3

•
Click Sum to calculate the sum of

the commissions.

count records

ﬁ nd largest value

ﬁ 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 ﬁ nished, once again

select the sum of the commissions

and the average of the rates.

total of

commissions

average

of rates

Figure 3–56