Question
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,
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started