Using the document titled Kays Flower Shop, answer the following questions to the best of your ability. Use IF, COUNTIF, COUNTIFS, AND, COUNT, COUNTA, COUNTBLANK, SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS

1.On July orders, show all invoices that totaled $50 or more for roses.

2.How much total did we spend on roses in July?

3.What is our total quantity of roses and vases for July orders? Find each separately and then together.

4.What is the total dollars spent on each invoice/shipment (look at identical invoice numbers)?

5.What was the total quantity for each invoice? (look at identical invoice numbers)?

6.What was the average cost per invoice/shipment?

7.What was the average cost per rose on July shipments?

PLEASE ATTACH EXCEL FILE WITH FORMULAS TO SOLVE QUESTIONS ABOVE