Exercise 7: Chart, Subtotals, Sorting, Filter of Data

 Exercise : Chart, Sort in, 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 type- Sporting goods.

5.

Print screen - Create and customize a book sales chart.

~ Conceptual skills - creative design for the look and feel.

V Technical skills - formula and formatting.

V Ethical skills - submit only your creative work.

V Professional skills submit on time, complete and well organize.

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 type- Sporting goods.

Filter by item type- Jewelry.

Filter by item type- Electronics.

Print Screen of Subtotals

Print screen - Create and customize a book sales chart.