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.xlsx with the name 4-Ex2-Johnson-SloanYourName.xlsx 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