Using the VLookup function, add the Branch location to the invoice data. Use the following information to add the name of the city in which the Branch is located to the data: Branch City 1 Guelph 2 Milton 3 Orangeville 4 Barrie 5 London 6 Hamilton 7 Kitchener 8 Oshawa 9 Windsor 10 St. CatharinesNiagara Step 3: Add a pivot table Use a pivot table to compute for each city Total Sales Dollars, Number of sales transactions, and average sales transaction. Include a filter to show these amounts per customer. Copy and paste the pivot below: Step 4: Prepare a visualization of Sales Prepare the visual presentation that you believe best tells the story of the relationship of Sales. Copy and paste the visualization below: Step 5: Provide Insights Provide at least three observations / insights gained from your pivot table and visualization below:

(Please help explain how to do each step)