Exercise 2: Importing and Analyzing Data for Johnson Equipment Johnson Equipment, the medium-sized laboratory equipment manufacturing company where you work, is in the process of acquiring Sloan Manufacturing, a smaller equipment manufacturer in the same industry. Then, you will use Excel to organize and summarize the data. Complete the following: 1. Rename initial Data file provided Sloan.xIsx with the name 4-Ex2-Johnson-Sloan- YourName.xIsx and save it in the Chapter 7 folder. Rename Sheet1 as Sloan. 2. Create a PivotTable report from the data in the Sloan worksheet that list the Sum of Total Products (rename as Total Products) for each Category name the worksheet as PT- Report-1 Format the Total Products Column as Number with no decimals 3. Create a PivotTable report from the data in the Sloan worksheet that list the Maximum of January thru June for each Product and filter by Category name the worksheet as PT- Report-2 4 - Add a column with the maximum of the 1 Semester. Select only one Category to test it. Use an IF to avoid have value zeroes if no data. 5- Add the recommended bar chart 6. Add your name and Current Date at the end of the workbook. 7. Save and close the 4-Ex2-Johnson-Sloan-YourName.xlsx workbook