Microsoft Office Tutorials and References
In Depth Information
You will find these examples in the Excel Chapter 25 file:
1. On the Second Example worksheet, you will
nd the data we used in this
nd total purchases by category of credit
card: American Express, Visa/MC, and other cards.
2. Find out, using the same data, the maximum amount spent by any customer for
each one of the Product categories: Clothing, Electronics, Furniture, Garden, or
3. Repeat the exercise. This time,
chapter. Use the Subtotal function to
nd the total Income by Gender.
3. Females $674,213 and Males $907,085.