EXERCISE 6: Charts, Subtotal, Sorting, Filtering of data - By Arvin Rae Javier

First I constructed a Table for this assignment and proceeded with the sortation...

SORTING THE DATA VIA ID

SORTING THE DATA VIA NAME:

SORTING THE DATA VIA TYPE:

SORTING THE DATA VIA LOAN COUNT:

After with the sortation I Filtered all the data for a more accurate look using the excel filter feature...

FILTERED DATA VIA ART MATERIALS:

FILTERED DATA VIA BAGS:

FILTERED DATA VIA BOOKS:

FILTERED DATA VIA CDs:

FILTERED DATA VIA CLOTHES:

FILTERED DATA VIA COMPUTER:

FILTERED DATA VIA LIGHTS, PHONES, AND PHOTOGRAPHY:

After Filtering the data, I went ahead and made a Chart and a graph

CHART AND GRAPH: