EXCEL PROBLEM - Show all formulas/macros, please!

1) Create a Pivot Table to show the total Unit Quantity for each Product sold per Representative.

2) Create a Graph showing the Total Value for each Year, broken down by Quarter.

Will thumbs up if all (or MOST) are correctly answered!

Total Value Unit Quantity 28 94 11 14 57 76 Product Pencil Binder Pen Desk Pen Set Unit Cost $1.29 $1.99 $1.59 $275.00 $18.99 Order Date Region 12/21/20 Central 12/4/20 Central 11/17/20 Central 10/31/20 Central 10/14/20 West 9/27/20 West 9/10/20 Central 8/24/20 West 8/7/20 Central 7/21/20 Central 7/4/20 East 6/17/20 Central 5/31/20 Central 5/14/20 Central 4/27/20 East 4/10/20 Central 3/24/20 Central 3/7/20 West 2/18/20 East 2/1/20 Central 1/15/20 Central 12/29/19 East 12/12/19 Central 11/25/19 Central Representative Andrews Jardine Jardine Andrews Thompson Sorvino Gill Sorvino Kivell Morgan Jones Kivell Gill Gill Howard Andrews Jardine Sorvino Jones Smith Gill Parent Smith Kivell Product Binder Binder Binder Pencil Binder Pen Pencil Desk Pen Set Pen Set Pen Set Desk Binder Pencil Pen Pencil Pen Set Binder Binder Binder Binder Pen Set Pencil Pen Set 7 3 42 55 62 5 80 53 96 66 50 7 4 87 46 74 67 96