EXCEL PROBLEM - Show all formulas/macros, please!

1) Use a formula to calculate the Total Value of each order (i.e Unit Quantity * Unit Cost)

2) Write a formula to calculate the Total Value of all Binders

3) Write a formula to calculate the Number of distinct orders placed for the Central region by representative Smith.

4) Use conditional formatting to highlight orders with a Unit Quantity greater than or equal to 90.

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