Microsoft Office Tutorials and References

In Depth Information

**Tutorial E: Guidance for Excel Cases**

FIGURE E-9

Restoring all data to screen

Each of the cells in the Total row has a drop-down menu. The menu choices are statistical operations

that you can perform on the totals

for example, you can take a sum, take an average, take a minimum or

maximum, count the number of records, and so on. Assume that the Time drop-down menu was selected, as

shown in Figure E-10. Note that the Sum operator is highlighted by default.

—

FIGURE E-10

Selecting Time drop-down menu in Total row

By changing from Sum to the Average operator, you find that the average time for all runners was

95.5 minutes, as shown in Figure E-11.