Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 11 AA ag Wrap Text v Accounting Ex AY -
Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 11 AA ag Wrap Text v Accounting Ex AY - O. Paste BIU = = Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data H9 X V fx =COUNTIF($F$9:$F$34,">=(4")*$C$3 F G H K M Discount 10.00% Minimum order for Discount 8.00%% GST 5.00% Order Date Last Name First Name Dish Number of Dishes Order Total Discount Subtotal PST GST Total Personal Message: 023-01-02 Cooley Adrianna Fancy Salad 42.00 5 2023-01-04 Bond Ariella Fancy Salad 140.00 5 2023-01-06 Cisneros Brendan Waffle Fries 120.00 $ 2023-01-11 Butler Charlotte Krabby Patty 242.00 5 2023-01-15 Frye Clarence Vegetarian Curry 85.00 5 2023-01-18 Jimenez Evelyn Mac and Cheese 150.00 5 2023-01-20 Howel George Fancy Salad 56.00 5 2023-01-24 Arellano Gisselle Fancy Salad 112.00 $ 2023-01-31 Jones Haven Mac and Cheese 100.00 5 2023-02-06 Aguirre Jasiah Vegetarian Curry 85.00 5 2023-02-10 O'connor Josiah Lasagna 162.00 5 2023-02-14 Osborne Karly Vegetarian Curry 170.00 5 2023-02-22 Wade Larry Pretty Patty 171.00 S 2023-02-27 Long Micheal Lasagna 216.00 5 2023-03-01 Gallagher Norah Lasagna 198.00 5 2023-03-07 Ferrell Octavio Krabby Patty 198.00 5 2023-03-09 Morse Paityn Mac and Cheese 70.00 5 2023-03-13 Crane Reese Spaghetti and Meatballs 184.00 5 023-03-15 West Roberto Pretty Patty 76.00 5 2023-03-16 Barron Sabrina Spaghetti and Meatballs 414.00 5 2023-03-21 Mcdowell Skye Spaghetti and Meatballs 345.00 5 2023-03-25 Dyer Tanya Spaghetti and Meatballs 322.00 $ 2023-03-29 Beard Troy Lasagna 216.00 5 2023-04-03 Wallace Walter Waffle Fries 130.00 $ 2023-04-07 Kelley Yadie Krabby Patty 330.00 5 2023-04-10 Christian Zackary Pretty Patty 114.00 $ Named Cells or Ranges Grand Total Name Cell or Range Customer Information Dish Information +Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibri (Body) 12 AA ab Wrap Text v Accounting 2 V AY . O. Paste BIUV OVA E = FE Merge & Center v $ ~ % " -00 Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles DV Filter Select Data C4 X V fx 10 A B C D E F G Dish Cost per Dish Number of Orders Total Number of Dishes Sold Total Number of Dishes with Discount W N Fancy Salad $ 14.00 Waffle Fries 10.00 Krabby Patty 22.00 6 Pretty Patty 19.00 Vegetarian Curry 17.00 Mac and Cheese 10.00 9 Lasagna 18.00 10 Spaghetti and Meatballs un 23.00 11 12 Total 13 14 15 16 17 18 19 20 21 22 23 4 tomer Information Dish Information + Finder
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