CSC 201 Homework Assignment 3, Fall 2015

First Name Last Name Address Item Price Calculate the Discount (amount and not Desription Johnny Chaanine Koura Book $ 100.00 10 Joe Khoury Tripolis Book $ 50.00 5 Anthony Nehmeh Tripolis Phone $ 200.00 40 Joelle Touma Koura Book $ 100.00 10 Mohammad Aziz Koura Phone $ 400.00 120 Joya Issa Beirut TV $ 500.00 150 Vera Amine Beirut Laptop $ 750.00 375 Paul Issa Tripolis Laptop $ 600.00 240 Calculate the Total Number of Brands using column A 8 Calculate the Total Price of Item Sold $ 1,750.00 Calculate the Number of Customer from Koura 3 Calculate the Sum of Items Sold to People from Koura $460.00 Draw a Pie Chart (search how to do it over the internet), the chart must be a pie chart of the sales and ite Calculate the Discount (amount and not Desription) Calculate the Total Price Condition if Price 10 $ 90.00 >=750 5 $ 45.00 >=600 40 $ 160.00 >=400 10 $ 90.00 >=200 120 $ 280.00 Everything Else 150 $ 350.00 375 $ 375.00 240 $ 360.00 chart must be a pie chart of the sales and item "Hint you can find it in the insert tab" Book Book Phone Book Phone TV Laptop Laptop if Price Discount 50% 40% 30% 20% g Else 10%