Bazooka Ltd sells used cars after a certain number of kilometres have been travelled. Each car has a code attached to it for identification purposes. Bazooka Ltd also has a commission structure that they have implemented to encourage the agents to sell as many of the cars that have reached the required kilometres, which are classified as available for sale. Bazooka Ltd has provided you with the spreadsheet below for your review and analysis: Bazooka Ltd has indicated that there are additional details below: (a) Standard private cars are sold after travelling 60000 kilometres; Luxury private cars are sold after travelling 45000 kilometres; Standard minibuses sold after travelling 55000 kilometres; Luxury minibus cars are sold after travelling 45000k travelling 30000 kilometres (refer to cells B21:B25). (b) The sales agents are awarded a sales commission based on the overall cars that they sell. They get a 5.5% sales commission if they sell 65% or more units of total cars available for of total units of cars available for sale in that same class of cars (refer to cell B4 and B5). The sales commission value is based on the required kilometres to sell for each class of car whilst considering the applicable commission rate. (d) The type of car is identified by the type code (refer to cells B12:B16 ). The type code is made up of the following structure. - Characters 1-2 : The initials relating to the type of car - Character 3 : Hashtag (#) -Character-4:ClasstypeCharacter5-7:Thebatchcode (e) A new type code was required to assist with the commission value calculations for each type of car (refer to cells D12:D16). The new type code is made up of the following structure. Required Use the information provided on the spreadsheet to answer the following questions. Note: Where it is indicated that your formula will be copied to other cells, your formula must take absolute and relative addresses into account. 6.1 Which spreadsheet formula was entered into cell C12 to extract the class type for the standard private car type? Note: Your formula will be copied to cells C13:C16. (2.5) 6.2 Which spreadsheet formula was entered into cell D12 to create the new type code for the standard private car type? Note: Your formula will be copied to cells D13:D16 6.3 Which spreadsheet formula was entered into cell D21 to obtain the unit sales for the new type code SPA-2022, from the sales code table in starting in cell E3? Note: Your formula will be copied to cells D22:D25. 6.4 Which spreadsheet formula was entered into cell E21 to determine the sales commission rate for SPA-2022? Note: Your formula will be copied to cells E22:E25. 6.5 Which spreadsheet formula was entered into cell C28 to determine the number of car types that qualified for a 5.00% sales commission rate? 6.6 Which spreadsheet formula was entered into cell C29 to determine the average sales commission value? Bazooka Ltd sells used cars after a certain number of kilometres have been travelled. Each car has a code attached to it for identification purposes. Bazooka Ltd also has a commission structure that they have implemented to encourage the agents to sell as many of the cars that have reached the required kilometres, which are classified as available for sale. Bazooka Ltd has provided you with the spreadsheet below for your review and analysis: Bazooka Ltd has indicated that there are additional details below: (a) Standard private cars are sold after travelling 60000 kilometres; Luxury private cars are sold after travelling 45000 kilometres; Standard minibuses sold after travelling 55000 kilometres; Luxury minibus cars are sold after travelling 45000k travelling 30000 kilometres (refer to cells B21:B25). (b) The sales agents are awarded a sales commission based on the overall cars that they sell. They get a 5.5% sales commission if they sell 65% or more units of total cars available for of total units of cars available for sale in that same class of cars (refer to cell B4 and B5). The sales commission value is based on the required kilometres to sell for each class of car whilst considering the applicable commission rate. (d) The type of car is identified by the type code (refer to cells B12:B16 ). The type code is made up of the following structure. - Characters 1-2 : The initials relating to the type of car - Character 3 : Hashtag (#) -Character-4:ClasstypeCharacter5-7:Thebatchcode (e) A new type code was required to assist with the commission value calculations for each type of car (refer to cells D12:D16). The new type code is made up of the following structure. Required Use the information provided on the spreadsheet to answer the following questions. Note: Where it is indicated that your formula will be copied to other cells, your formula must take absolute and relative addresses into account. 6.1 Which spreadsheet formula was entered into cell C12 to extract the class type for the standard private car type? Note: Your formula will be copied to cells C13:C16. (2.5) 6.2 Which spreadsheet formula was entered into cell D12 to create the new type code for the standard private car type? Note: Your formula will be copied to cells D13:D16 6.3 Which spreadsheet formula was entered into cell D21 to obtain the unit sales for the new type code SPA-2022, from the sales code table in starting in cell E3? Note: Your formula will be copied to cells D22:D25. 6.4 Which spreadsheet formula was entered into cell E21 to determine the sales commission rate for SPA-2022? Note: Your formula will be copied to cells E22:E25. 6.5 Which spreadsheet formula was entered into cell C28 to determine the number of car types that qualified for a 5.00% sales commission rate? 6.6 Which spreadsheet formula was entered into cell C29 to determine the average sales commission value
