EXERCISE 7: CHARTS, SORTING, FILTER, SUBTOTALS

1. Print screen Sort the data by ID A-Z smallest-highest. 

2. Print screen Sort by Name A-Z sort ascending. 

3. Print screen Sort by Loan Amount Z-A Sort Highest to Lowest. 

4. Print screen Filter by Item types

5. Print screen - Create and customize a book sales chart.

ID A-Z smallest-highest

A-Z Sort ascending

Loan Amount Z-A Sort Highest to Lowest

Filter by Item type - Seed Packets

Filter by Item Type - Miscellaneous

Filter by Item Type - Food

Filter by Item Type - Equipment

  Subtotals and Grand Total

Book Sales Chart