Microsoft Office Tutorials and References
In Depth Information
Tutorial E: Guidance for Excel Cases
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.
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.