Show all step and formulas used

Count, CountA, Countblank, Countif, Countifs, Average, Averageif, Averageifs, Median

Tiger Company sells used cars. Tiger has 3 different locations and 12 total salespeople. Data about each salesperson is as follows: Years of Number of cars Total price of Salesperson Location Experience sold all cars sold Angie Montgomery 1 12 $157,321.77 Bryon Elmore 4 14 $99,999.99 Celinda Opelika 7 19 $178,547.25 Deron Opelika 15 25 $479,500.07 Emelia Montgomery 12 25 $548,347.00 Frank Opelika 2 4 $25.100.72 Gena Elmore 14 7 $106.855.97 Harvey Montgomery 8 12 $238,654.21 Imogene Opelika 8 8 $350,471.82 Jorge Montgomery 4 35 $764.318.50 Katalin Elmore 8 22 $175,687.74 Levar Montgomery 2 10 $72.089.36 All of the required formulas must use at least one function from the material in chapter 11 that was covered in class on Wednesday, September 29. Each of the items must be solved using a single formula (nesting is allowed). Your formulas may use the numbers listed in the required items. . Required: Enter the above data, as shown, with Salesperson starting in cell F1. o This is the same data that was used in assignment 8. For items 1-8. label each item in column B and put the formula that calculates the answer in column C. 1. How many total salespeople work for Tiger Company? You must use cells from column F as the range/values in your formula. 2. How many of the salespeople work at the Montgomery location? 3. How many of the salespeople have more than 5 years of experience and sold at least 12 cars? 4. What is the average number of cars sold by each salesperson at the Elmore location? 5. What is the median of the total price of all cars sold? 6. What is the mode of the number of cars sold? 7. Calculate the average number of cars sold by employees at the Opelika location that have less than 10 years of experience. 8. How many salespeople have sold 15 or less cars with a total price of less than $150,000