Preparing Excel Visualizations to Analyze Industry Trends Over Time The file associated with this exercise includes data extracted from the Estimates of Monthly Retail and Food Services Sales by Kind of Business obtained at the United States Census Bureau at https://www.census.gov/retail/index.html. In this exercise, we will analyze the trends in sales of automobile and other motor vehicles over a five year period. Required 1. Download the following Excel file: Estimates of Monthly Retail and Food Services Sales by Kind of Business 2. Transpose the data so that it is shown in a column instead of a long row. Hint: Copy, Paste Special, Transpose. 3. Prepare a line chart showing trends in the sales of automobile and other motor vehicle dealers from 2017 to 2021. Hint: Highlight data and open Insert tab. Click Line graph in Charts group and select one of the 2-D graphs. 4. Answer the following questions using the visualization for reference. a. What was the lowest month of sales during the period of January 2017 to June of 2021? Answer 1 of year Answer 2 b. What was the peak month of sales during the period of January 2017 to June of 2021? Answer 3 of year