Apply the same steps as Lab $3-4$ to the Lab $3-4$ Alt Data.xlsx dataset.Required:

Create a pivottable and pivot chart to assess the sum of raw materials quantity ordered by year.

Create a slicer to interactively filter the pivot chart by state from which the products were ordered.

Adjust the pivot chart to show horizontal bars.

Assessment:

Take a screenshot of the pivottable and pivot chart without any filtering. Label it "Lab $3-4$ ALT Submission.jpg$."$

Take a screenshot of the pivot chart as a bar chart $($horizontal bars$)$ with the slicer in view. Label it "Lab $3-4$ Submission ALT $2.$jpg$."$

Answer the multiple$-$choice questions in Connect.