Question 1 [20] Cape Distributors is a liquor wholesaler based in Cape Town. Customers who place the exact order quantities weekly get a 5% discount on their invoice value. Management has put forward a proposal to apply a 5% discount on invoice values only above R100 000 . Below is the information provided. Answer the following questions. Notes: Do not complete calculations manually. Total marks will only be awarded if formulas are used. Required: 1.1 Create a spreadsheet with the provided information. (3 marks) 1.2 Arrange the liquor brands in ascending order ( 2 marks) 1.2 The total quantities of liquor sold. ( 2 marks) 1.3 If a 5% discount is applied to every sales invoice, calculate the discount value. ( 3 marks) 1.4 What sales value will the company realise after the 5% discount in Q.1.3 ? (2 marks)