Question: View Content Create Protest Links Insert EXERCISE-excel X LABS EXERCISE Excel... Net Price for Whole Cake Decision Cake Code 1001 1002 1003 1004 1005 1006

View Content Create Protest Links Insert
View Content Create Protest Links Insert EXERCISE-excel X LABS EXERCISE Excel... Net Price for Whole Cake Decision Cake Code 1001 1002 1003 1004 1005 1006 1007 1008 1009 Kind of Cake Apple Pie Strawberry Pie Cheese Cake Banana Cake Tiramisu Fruit Cake Chocolate Cake Baklava Kazan Dibi Price of Whole Discount for Price of Slice $ Cake $ Whole Cake 2.5 18 2.5 18 3 20 2.5 18 5 35 3.5 20 4 25 4.5 30 3 20 Average Price: Maximum Price: Minimum Price: Burcu's Patesserie has computerized its system and wants to make some calculations Firstly calculate and find the average, maximum and minimum prices for a slice of cake and for the whole cake Calculate the discount price for Whole Cake if the discount amount is 15% in column E (Whole Price*15%) Then Calculate the net price for Whole Cake in column F (Price for Whole Cake - Discount for Whole Cake) Decide if a slice of cake is expensive or cheap in column G (if the amount is larger than 3 then its expensive otherwise cheap) Draw any type of graph to show the cake names and prices

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!