Reference no: EM132943411

1. Create an appropriate worksheets based on the work you have done above. Enter your own data. Save your worksheets as portlouis, curepipe and vacoas.

2. Save your work into a new workbook as yourlastname.xls. Please note that only one workbook must be created.

3. Insert a new worksheet in your workbook - name it 'consolidated worksheet'. Use appropriate formula to consolidate the 'quantity' and 'sales' figures from the different worksheets you created in step 2 above.

4. Salespeople who have sales greater than 30,000 will receive a 10% commission. Those who have achieved a sales between 10,000 and 30,000 will receive a 5% commission and those who have achieved a sales of less than 10,000 will not receive any commission. Calculate the commission in the 'Port Louis' worksheet for each sales person using absolute referencing and the 'if' formula.