1) Cycle: Price € 200 each 2) washing machine: Price € 800 each 3

Subject:MS ExcelPrice:5.99 Bought3

Share With

1) Cycle: Price € 200 each 2) washing machine: Price € 800 each 3. Dryer: Price 99 € each 4. Apple: Price € 5 per kilo. For spring and summer 2018 the items were sold as follows: March 21, 2018: 23 Cycle and 33 washing machine at the normal price May 32, 2018: 52 cycle and 4 washing machine at the normal price 07/07/2018: 1 dryer at the normal price 10.03.2018: 30 kilos of apple at the normal price 08/29/2018: 6 cycle, 7 washing, 1 dryer and 40 kilos of Apple. All items were sold at a discounted price of 70% off. Please create an Excel pivot table and MS Access queries to answer the following questions: How many items of each type were sold by July 31, 2018? How was the total turnover in 2018? What is the average price per item?