Using appropriate Excel formulas/features complete the following tasks: 1. In all data sets change WWSP (SalePersonID) to SP#, where #represents the number. This should reflect on in all data sets where SalePersonID is included. B D 2 SP1 3 SP2 Erasmus Ndebane 1 salesperson_id salesperson_name salesperson_surname salesperson_phone salesperson_email Bonita Aggie 4 SP3 Connie Vraagom 5 SP4 Vince 6 SP5 7 SP6 Kopano Justin Ephraim Moshesh Green +27 84 575 4452 +27 15 782 8176 +27 20 638 6911 +27 25 647 5851 +27 44 882 4122 +27 28 213 2296 E store lacinia.mattis@aol.ca Canal Walk Canal Walk Canal Walk Canal Walk Canal Walk Canal Walk eu.euismod@icloud.edu amet.risus@yahoo.com tincidunt.pede@icloud.net vulputate.dui.nec@aol.couk eros.nam@aol.org 2. Make sure the correct formatting is included in all data sets (e.g. Invoice numbers and date formats are correct) 3. Referring to the Stores data set, make sure there relevant values appear in each field. 4. Find all duplicate entries in the transaction data or other data sets, insert screenshots of the duplicate entries and explain how these duplicate entries were corrected. 5. Refer to Cashbook dataset, using relevant INDEX, MATCH and MAX functions display sales person ID with the highest sales: J8 fx D 1 SalesPers TransactionDate Amount (incl. VAT) 2 WWSP1 01 03 2021 3 WWSP10 01 03 2021 4 WWSP11 01 03 2021 5 WWSP12 01 03 2021 6 WWSP13 7 WWCD14 2294.06 291.1 112.66 2367.36 42.19 E F G H Largest sale? Sale Amount WWSP13 10829.06 K 01 03 2021 01.02.201 450 71 6. Refer to Transaction dataset, include a column 'Vat Amount'. Using an appropriate formula, calculate the percentage amount of vat and insert the vat amount in the column 'VAT Amount. 7. Using the IF function write a formula that will return the Product Name once Product ID is entered in a cell. This formula can be created anywhere in the Transactions Data tab. 7. Using the IF function write a formula that will return the Product Name once Product ID is entered in a cell. This formula can be created anywhere in the Transactions Data tab. Product ID 4 Product Name Home and Lifestyle 8. Using appropriate formulas return the total number of transactions for each store (1 to 10) - count the number of transactions for a particular store ID. Then return the maximum number of transactions. Store ID Number of Entries 1 4631 Product ID Product Name 4 Home and Lifestyle 8. Using appropriate formulas return the total number of transactions for each store (1 to 10) -count the number of transactions for a particular store ID. Then return the maximum number of transactions. Store ID Number of Entries 1 4631 2 4374 3 5454 4 4868 5 5437 6 4565 7 5196 8 5258 9 4677 10 5593 Store with maximum entries = 5593 9. Provide a detailed explanation on how fraud could be detected in Excel data