Answered step by step
Verified Expert Solution
Link Copied!

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 -

image text in transcribedimage text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistical Inference

Authors: George Casella, Roger L. Berger

2nd edition

0534243126, 978-0534243128

More Books

Students also viewed these Mathematics questions