b. Use the Excel worksheet data below to solve thefoh'awing questions. XYZ COMPANY SALES PERFORMANCE (i). Write a formula to calculate the Total Sales in column G and Row 12. (2 marks) (ii). Write formulas to calculate the Average Sales for Albert and Lucy as it should appear in Excel. (2 marks} (iii). How would you calculate the Commission for each salesperson? (2 marks) (iv). Calculate the value for the function =SUM1F(D8:DIO, >=F7) (2 marks) (v). What is the value fOr =AVERAGEIFlBzBl0,C6:CB=799) (2 marks) (vi). Calculate the value for =PRODUCT(B 12:012) {2 marks) (vii). You are asked to compare QTRl and QTR3 sales for all salespersons in the above table using a chart: (a).What range of cells do you need to select and how would you select it? (2 marks) (h).What type of graph would you use? (2 marks)