I don't know how to start and make excel sort it for me.

Financial Accounting Data Analytics Case Overview The demand for college graduates with data analytics skills has exploded, while the tools and techniques are continuing to evolve and change at a rapid pace. This case illustrates how data analytics can be performed using Excel. As you analyze this case, you will be learning how to drill-down into a company's sales data to gain a deeper understanding of the company's sales and how this information can be used for decision-making Background This KAT Insurance Corporation data set is based on real-life data from a national insurance company. The data set contains more than 65,000 insurance sales records from 2017. All data and names have been anonymized to preserve privacy. This is an individual assignment. No two excel files should look the same. Requirements - All of these steps must be done in Excel. - 75 Points To follow are the requirements for analyzing sales records in the data set. All of the answers to the following questions should be shown in Excel. Be as creative as you like. However, your answers should be clearly labeled, and it should be easy to identify. No manual calculations are allowed. If you need help, log on to Lyndia.com for assistance with Excel. 1. There are some typographical errors in the data set in the Region and Insurance Type fields. Find and correct these errors. 2. Rank the states from the highest total insurance sales to lowest total insurance sales. Sort the data by sales, from highest to lowest. a. Which state had the highest sales? What was the total dollar amount? b. Which state had the lowest sales? What was the total dollar amount? c. What is the average amount of insurance sold per state? d. How many insurance policies were sold in each state? e. Do any states fail to meet the $800,000 minimum sales level? Sort the state data by average policy amount, from highest to lowest. a. Which state had the highest average policy amount? b. Which state had the lowest average policy amount? 4. Rank the regions from the highest total insurance sales to lowest total insurance sales. Sort the data by sales, from highest to lowest. a. Which region had the highest sales? What is the total dollar amount? b. Which region had the lowest sales? What is the total dollar amount? 5. Who is the leading salesperson in each region